SSIS ODBC Help Please

• Vertigo44

  SSCarpal Tunnel

  Points: 4055

  More actions

  June 14, 2011 at 9:18 am

  #242105

  To be honest I don't have any experience with BIDS or VS and have never created an SSIS package or done any development stuff.

  Here's where I stand:

  1. Server where I want to pull data from (Cobol datasource)

  2. Local client with SQL Server, BIDS, and the DSN/ODBC connection to the Cobol datasource

  3. When I opened Excel >> Data >> Connections >> ADD >> Connection files on this computer >> my ODBC... I am prompted with a 'Select a Table' box with all the tables in the Cobol Datasource.

  Now, I want to use BIDS to see and retrieve this data so I can create an SSIS package to put the data into the destination server. However, after creating the Connection manger and successfully testing its connection, I then attempted to create a Data Flow Source but can't seem to access anything...

  Should/Can I be using SSMS to do this?

• Brandie Tarvin

  SSC Guru

  Points: 173104

  More actions

  June 15, 2011 at 7:54 am

  #1338987

  Can't access anything?

  Please be more specific in the steps you use to create your Data flow. Tell us what items you are choosing and how you're connecting them together.

  Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.