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

		Wrox Programmer Forums > SQL Server > SQL Server DTS
DTS package fails: [DBNETLIB].....

SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

May 19th, 2005, 07:29 PM

rrhandle

Registered User

Join Date: May 2005

Posts: 8

Thanks: 0

Thanked 0 Times in 0 Posts

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

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with DTS PACKAGE	mxwebb	SQL Server DTS	1	November 28th, 2007 05:16 PM
DTS Package Fails When Scheduled	kwilliams	SQL Server DTS	4	December 23rd, 2005 02:47 PM
DTS Fails when called from VB	levinll	SQL Server DTS	1	November 10th, 2005 02:05 PM
DTS Package Neither Succeeds Nor Fails	Crowandazi	SQL Server DTS	1	March 21st, 2005 11:27 PM
DTS Schedule import data fails	ppenn	SQL Server 2000	4	November 5th, 2003 06:48 AM