I am using SSIS 2008 and having a problem with pulling character data values from an Informix source. The etl runs fine, it pulls records from the source database and poulates them in the target, but all the fields that are char/varchar data type comes out blank in the target (no prob loading numerical values). I have tried loading data in a SQL Server table and also in a text file, the result is the same. Here is info on diff software ver etc.: The etl is running on a Windows Server 2008 R2 standard (64 bit OS). SSIS ver is 2008, 64 bit run time for the project is disabled (etl is running in 32 bit mode). Informix ODBC is ver 3.70.TC3 it's a 32 bit driver, and DSN has been setup under 32 bit ODBC (C:\Windows\SysWOW64\odbcad32.exe). I am using ADO NET component to connect to the ODBC dsn. After writing my query in the ADO Net, when clicked on the "preview" button I can see all the correct data. Also, I am able to run a query against this ODBC dsn using the "Server Explorer" tool in BIDS -- query result shows all the correct values, I can copy the result and paste it in a notepad. But when the etl is run, values for all the fields that are char/varchar comes out blank in the target. Please let me know if any additional info is required. Any help/insight into it will be greatly appreciated. Thanks, Manish

Hi Manish, The issue might due to incompatibility of data types between Informix and SQL Server, please refer to the following artilce: Informix (IDS) Data Types - Mapping to Microsoft SQL Server: http://www.ispirer.com/wiki/sqlways/informix/data-types-to-sql-server I suggest you can save the Informix data to a flat file and then use this file as a SSIS source to load the data into SQL Server. Thanks, Eileen

Hi Eileen, Thank you for your input, but I have already tried writing the output to a text file and even in the text fiile char/varchar columns come out blank. Manish

Hi Eileen, Thank you for your input, but I have already tried writing the output to a text file and even in the text fiile char/varchar columns come out blank. Manish

Any more information on this? I'm having the same exact problem. Thanks, John

This is what fixed the problem for me: On the ADO.NET source editor, change "error" property of string columns to "Redirect row": Hit Ok to close the editor, save the package and run it. You should see all the columns correctly populated in your target table. ~Cheers Manish

This is what fixed the problem for me: On the ADO.NET source editor, change "error" property of string columns to "Redirect row": Hit Ok to close the editor, save the package and run it. You should see all the columns correctly populated in your target table. ~Cheers Manish