Hi allI am involved in a project to create a reporting database from an Avaya telephony system (runningon anInformix 2000 db) into a SQL 2005 database. Due to the fact that there are no Informix skills here my immediate thinking was to use SSIS to do the transfer of the data.I have several issues though:1. We only have an Openlink ODBC drivers - not sure if this is actually an issue -I read somewhere it was but I can connect to the database - just can't get any data out of it!!!!!!!!!!!2. I understand that I must use an ADO.Net component for the source. I can get a list of tables but if I preview the table I getthe followingerror:TITLE: Microsoft Visual Studio------------------------------ There was an error displaying the preview. ------------------------------ADDITIONAL INFORMATION: ERROR [37000] [OpenLink][ODBC][Informix Server]A syntax error has occurred. (-201) (olod4032.dll) ------------------------------Ideally I would like to use the wizard as I am not doing any transforms; I amsimply pulling certain columns from the Informix db tables and loading them into the SQL db tables. However there is no source for the Informix db. I can use .Net Framework Data provider for Odbc but then it asks me for a Named ConnectionString and a Source. I put in the named ConnectionString as my ODBC source name but I haven't a clue what to enter for the Source/Driver section. I did find (under the Connection manager) something similar where it can build the connection string for me but I am not sure what to enter here - it keeps telling me it can't find my user name and password???My connection string in the Connection Manager is:Dsn=CMS;Driver={C:\Program Files\OpenLink\olod4032.dll};uid=DBA;servertype=Informix 2000;host=10.20.255.56;port=5000;database=cms;options=CMS;fetchbuffersize=30;nologinbox=No;protocol=TCP/IP;readonly=No;deferlongfetch=YesBut there is a section here for the password which HAS to be filled in otherwise it won't work.I am wondering whether this password is not being stored anywhere and that is part of the problem??This is all very frustrating as I am new to SSIS and can't seem to find help anywhere - PLEASE HELP!!!I hope my ranting is making sense?????I have read some other posts about non-SQL datasources and SSIS being an issue but they were old and I am hoping the issues have all been fixed!!!!!Your responses are appreciated,RegardsSarah

http://ayende.com/Blog/archive/2007/07/15/SSIS-15-Faults.aspxTry re-deploying your package.

Hi Sarah, I'm experiencing the same exact problem you did, except with SSIS 2008. Do you happen to recall how you resolved this problem? Thanks! -Ethan