Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS package fails: [DBNETLIB].....

Status
Not open for further replies.

rrhandle

Programmer
Dec 26, 2001
193
0
0
US


SQL Server is running on my PC. The server name is 'ASPEN'. When I create a DTS package to export a local database to our live site, I must use 'LOCAL' for the server name, not 'ASPEN'. Everything runs fine the first time, but later, when I try to execute, or even view, the local package I saved, I get the following error:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.

Can anyone explain this?
 
Sounds like a permission problem or a missing linked server.

Thanks

J. Kusch
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top