Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  SSIS Package Pulls Columns As NULL

Author  Topic  jpichie Starting Member 1 Post Posted - 2010-12-02 : 11:12:11 Hey All: This is my 1st post here, hoping someone can help me out. I recently setup a new server, running sql 2008R2 with Business Intelligence 2008. I upgraded all my DTS packages from the old server (running sql/busines int 2005). The packages upgraded fine, and I started running them. Data was being pulled, but for some reason some columns are being pulled as NULL. The data is being pulled from a ZORTEC database (which I believe is irrelevant) because I tried the same queries (and ZODBC driver, and DSN) using Query Tool for ADO, as well as creating a VB project under VS 2010, and all the data is pulled correctly. I ended up discovering, that if I move one column to the end of the query, that all the data in that table is fine, no NULLs are pulled. If I move it to the beginning of the query, some columns get pulled as NULL. does this sound like a data type problem? Or maybe there are some weird characters? The problem column only has 0 in every row, so I am not seeing anything odd. Also, in the SQL Destination portion of the package, I am simply clicking New for the table, and letting SQL create the table with data types. This is how I did it on the old system without any issues. Any help is greatly appreciated, as this is becoming extremely frustrating. Thanks in advance.