February 12, 2002 at 10:23 am
I want to read data from a table using DTS. The data source is the "Microsoft ODBC Driver for SQL". But I can't find where to specify the actual "connectoid" I want to use!
TIA,
Bill
February 12, 2002 at 10:33 am
Not sure what you mean. What is a connectoid? Where is the data? In SQL Server?
Also, what version of SQL are you using?
Steve Jones
February 12, 2002 at 2:22 pm
Sorry about being unclear. I was able to resolve the issue myself. The ODBC DSN mapping under DTS (Sql 7) is so seamlessly done that I didn't recognize it pulls in the needed tables and presents them like they are local tables.
Bill
February 12, 2002 at 3:08 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply