Other ODBC

Last Post 22 May 2008 07:41 AM by sql-tips. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sql-tips
New Member
New Member

--
16 Apr 2008 02:50 PM
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-tips
New Member
New 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-tips
New Member
New 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.
SQLUSA
New Member
New Member

--
23 May 2008 12:28 AM
Check out this link: http://ssis.wik.is/

Let us know if useful.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2005 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/
You are not authorized to post a reply.

Acceptable Use Policy