SQL Error trying to execute a DTS script

[paqguy]

I created a DTS script using the wizard. Saved the script - all the while logged in as SA. Try to execute the script (still logged in as SA) and get the following error:

Error Source: Microsoft OLE DB Provider for SQL Server

Error Description: [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.

Any ideas? paqguy - Shaun Beane
Instructor/Developer
sbeane@adelphia.net

 

[tlbroadbent]

Verify the properties in the connection of the DTS package are correct. Check the data source, server name and authentication mode (Windows or SQL Server authentication?).

FYI: There is a new forum for DTS on Tek-Tips. Please post future questions about DTS in forum961 - Microsoft SQL Server: Data Transformation Services. If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm