Post reply

Connecting to an ODBC data source?

  • January 9, 2008 at 1:12 pm

    #119531

    I am very new to SSIS but I can't figure out how to simply connect to an ODBC data source from SSIS. The only option I see is OLEDB. I have a DSN for a Btrieve database. I can connect to it and query the database from Visual Studio, Crystal Reports etc. Help?

    Thanks,

    Chris

  • January 9, 2008 at 2:31 pm

    #766409

    I dont' have any ODBC data sources to work with here, but in my one SSIS Package, if I right click in the Connection Managers area and choose "New Connection..." there is an option for ODBC. Choose that, then click the New... button and see if your existing ODBC connection is anywhere on that list.

    -Mike

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply