August 16, 2010 at 2:41 pm
I have an ssis package that exports data to Excel files. I have numerous files to which this export needs to occur. All of the exports work except for one. The single failure exports 27000 rows of empty data into the file. The column headers are properly populated in the destination but the rows are all empty. All other destinations populate the rows with data.
This worked last Friday and today (Monday) it does not. Any ideas on what to check?
SSIS 2008 32 bit.
If I run the query, used in the data source in the package, from SSMS - I get all of the appropriate data. There are no Left joins in the query. There are no null values returned by the query from SSMS.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 16, 2010 at 2:59 pm
Ok - very odd. It just started working again. I added a data viewer in the flow and all data could be seen in the viewer and now it exports to the file.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 17, 2010 at 12:57 am
That is indeed very odd. Maybe even SSIS can have the Monday blues?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply