Wednesday, March 21, 2012

DTS connecting to CA Datacom

I am trying to import data from a CA Datacom database on a mainframe using SQL Server2000 Data Transformation Services. I can sign in with my username and password and see all the CA Datacom tables listed in DTS. When I select a table I get an error:

"Your provider does not support all the interfaces/methods required by DTS."

I am using the ODBC driver: CA Datacom/DB version 78.73.7970.

I have read in some other posts on the internet of people using this ODBC driver and being able to import data into SQL Server. Anybody have any ideas? Anybody doing this successfully?

your input is greatly appreciated.Ok.. I figured it out. For anyone else that may ever try doing this:

Instead of selecting the CA /Datacom DB driver in the pulldown list in DTS, I chose "Other ODBC data source" and this let me download tables.

No comments:

Post a Comment