DTS: Possible to reuse DSN info when creating DTS connection?
Posted on 2001-06-07
I'm using DTS to transfer data from Excel etc. to different MS SQL 2000 databases.
To create a new DTS connection to MSSQL you need to specify:
- UseTrustedConnection (NT authentication used)
All these parameters are already present in my DSN (ODBC or OLEDB), and I only want this information in one place(the DSN). How can I reuse this information (either by telling DTS connection to use DSN or by getting the info from DSN and manually provide them to the DTS connection) ?
Any help would be appriciated.