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

  • December 13, 2007 at 9:01 am

    #759886

    Should be able to use ODBC, although I've never tried....

    1. Set up ODBC data source in windows control panel

    2. Inside SSIS/visual Studio package, right click inside connection manager area, choose "New Connection..."

    4. Choose ODBC, then "Add", then "New"

    5. Pull your drop down down, and add the connection you setup in windows from step 1

    6. Now your connection is setup.