Other ODBC

I have DTS package in SQL 2000 and needs to migrate into SQL 2005 SSIS. I used Other ODBC daa source in SQL 2000 and didn't find equivalent in SQL 2005 SSIS. How I shall do that?

Any help appreciated

sql-tipsNew Member

22 May 2008 07:41 AM

I am reading from cobol files. I used third party software to read the cobol files and they provided ODBC connectivity I used this ODBC as other ODBC driver, similar thing I couldn't find in SSIS.

sql-tipsNew Member

22 May 2008 03:09 PM

My main problem not with cobol files. In SQL 2000 when I try to import data and select a data source I get big list with different ODBC options that includes "Other ODBC" there I can easily select my ODBC. But in SQL 2005 I have few options in Data Source which doesn't include "Other ODBC" Driver.