I am trying to pull data from ODBC Source(non relational) to SQL Server 2005 using SSIS. Now I did some research and found that for using ODBC source we have to use Data Reader source which uses ADO .NET connection. so I created a ADO .NET connection manager. so far so good.
Now when it try to assign this ADO .NET connection to my Data Reader Source it gives me the following error
"Error at Data Flow Task [DataReader Source ]: System.Data.Odbc.OdbcException: ERROR [IM001]
Driver does not support this function."
I thought there was some problem with my DSN so i tried to import a table from ODBC source into Access DB and it worked so I know my DSN is working.
So do we require different version of ODBC driver for SSIS? I have Transoft ODBC driver, version: 4.00.00.00