I'm having a problem with an SSIS, which basically retrieves the data from a table and exports it to an Excel. The problem is that when I work with a limited number of records (1000 records) Excel generates me without problems, but when I remove the top and try to generate it with the total of the records does not generate the file.
I'm working with version 2008 and I'm calling SSIS through a SQL job.