SSIS Randomly Empties Out Column Data While Using Flat File Source

Ahmad Siddiqi


I'm having a problem using the Flat File Source while using the underlying .Net classes to execute SSIS Packages. The issue is that for some reason when I load a flat file it Empty's out columns randomly. Its happening in the Flat File Source Task. By random I mean that most of the times all the data gets loaded but sometimes it doesnt and it empty's out column data. Interestingly enough this is random and even the emptying out of columns isnt a complete empty, its more like a 90% emtpying. Now you'll ask that is the file different everytime and the answer is NO. Its the same file everytime. If I run the same file everytime for 10 times it would empty out various columns maybe 1 of those times. This doesnt seem to be a problem while working with dtexec or the Package Executor utility. Need Help!!

Jamie Thomson

Sounds strange.

Does it definately only happen when executing from the API

If you can build a repro then you would do well to submit it to http://connect.microsoft.com and talk to Product Support Services (PSS).

-Jamie

Ahmad Siddiqi

Seemingly it is the Object Model. I load the package using Apartment Threaded. LoadPackage([FilePath], null). The null sets it to using Apartment Threaded where as the other method uses Neutral Threaded. I am calling it through a webservice which shouldnt cause a problem, which means that all the code used to provide properties and set various variables inside the package is on the server. I want to see if I get any responses here on this issue. Opening a ticket with Microsoft is definitely my next bet.