Hi, I'm trying to run a SSIS package that reads data from mainframe and loads into a SQL Server table. This package is already deployed to Production and works fine but if I try to run a copy in my BIDS I get NULL values for all char columns. I've created a simplified version of it keeping just the Data Source Reader using iWay ODBC driver and a Flat File Destination. Also included a Data Viewer in the flow between them. The columns are all NULL both in the Data Viewer and in the output File. I was able to get the correct data through a Data Query in Excel, using the same ODBC driver/dsn. BTW, all char columns have values <> NULL at the source DB. Pls note: the package works in Production server. Can it be related to BIDS configs or my desktop code page configs? Any help much appreciated!

It could be the code page used, please review this portion.Arthur My Blog

Thanks Arthur. I've added all EBCDIC code pages to my desktop Region settings but didn't work. It's interesting that I can get the data using an Excel query, so it seems that code page is ok.

SOLVED! The issue was with .Net Framework 2.0 sp2 and 3.5 sp1 using a third-party ODBC driver (iWay in my case). Just uninstalled both versions of the framework and reinstalled version 3.5 from link below: http://www.microsoft.com/downloads/en/details.aspx?FamilyId=333325FD-AE52-4E35-B531-508D977D32A6&displaylang=en