I am using a Data Flow Task to insert approx. 2000 records from SQL Server into a DB2 table.
My rows get written to the destination table without issues. However, some of the columns do not get populated. My mappings are set up correctly, and valid data is found in the source table.
Sometimes the problem columns get partially populated, other times they are empty. It almost seems like the insert gets interrupted.
The same package works just fine using SSIS 2005. Is there some sort of insert buffering I can adjust?
Is this a bug with 2012?
Thanks!