Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS and ODBC - Is there a way to use ODBC Connections in SQL 2K5 RE: SSIS and ODBC - Is there a way to use ODBC Connections in SQL 2K5

  • August 25, 2010 at 6:03 am

    #1211567

    1. Create a ODBC connection in Control Panel.

    2. Create a ODBC connection from connection manager is SSIS and map it to the custom connection created..

    3. Implement a Script Task to manipulate with data stream from ODBC provider.

    OR

    You may get the necessary drivers/providers installed which are compatibkle with latest SSIS release.

    Raunak J