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 2005 Forums  SSIS and Import/Export (2005)  [IM001] Error in SSIS Designer

Author  Topic  zezu10 Starting Member 3 Posts Posted - 2008-01-17 : 05:37:51 Hi all, I've been tasked to do some investigation at my workplace as to the best way to move forward with changing from our SQL 2000 DTS' to SQL 2005 SSIS packages. Our main issue at the minute seems to be that we are using ODBC drivers to pull many of the raw tables which we then manipulate into our own SQL Server tables. I've had a go at pulling them through the Datareader Source, using the ODBC provider and I recieve the following error; Error at Data Flow Task [DataReader Source [1]]: System.Data.Odbc.OdbcException: ERROR [IM001] Driver does not support this function. Would this be to do with our ODBC drivers being out of date? Does anyone know how to resolve this issue?