DataCom

• coenie-353912

  SSChasing Mays

  Points: 615

  More actions

  August 25, 2010 at 3:23 am

  #141761

  I have to extract data from a DataCom database (V10), can I do it using SSIS (2005)

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  August 25, 2010 at 5:59 am

  #1211563

  Though by default there are no providers for Custom sources. You may implement the following:

  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 compatible with latest SSIS release.

  OR

  You may use a ADO.NET provider and choose ODBC Data Source

  Raunak J

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  August 25, 2010 at 9:21 am

  #1211718

  I think all of those are good answers..

  CEWII