SQL Server Performance Forum – Threads Archive
DSN on SQL Server
How do I set up a DSN on SQL Server so that I can schedule a DTS package to run every night? wixAre you looking for the connection string?
http://www.insidesql.de/component/option,com_bookmarks/Itemid,42/task,view/catid,9/id,817/ ———————–
–Frank
http://www.insidesql.de
———————–
??? What would you need a dsn for though if you have DTS? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
quote:Originally posted by derrickleggett
??? What would you need a dsn for though if you have DTS?
MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
[email protected] When life gives you a lemon, fire the DBA.
The dsn needs to be on the server where SQL server resides in order to import data from a multi-valued database. wix
In Windows 2000 and above it’s under Administrative Tools -> ODBC. Set up a System DSN and you should be fine.
]]>