Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 moving packages to remote server

Author  Topic 

-Dman100-
Posting Yak Master

210 Posts

Posted - 2006-05-18 : 00:15:15
I've created several DTS packages on my local testing server. I have an instance to the remote production server under my local server group that I setup using client network utilities.

I moved the packages over to the remote server and now I'm trying to change the connection properties.

I'm not having much success as I get a package error

Error Source: Microsoft JET Database Engine
Error Description: Failure creating file

I've placed the source files in the correct folder on the remote server. I'm trying to use a UNC path:

\\remote_servername\dts packages\replist.xls

on my local testing server I used an absolute path:
c:\replist.xls

Not sure if that is why the problem is occuring?

This is my first attempt at moving dts packages, so any help is appreciated.

Thank you.

ciaran
Starting Member

40 Posts

Posted - 2006-05-24 : 10:49:15
Where are you executing them from
Go to Top of Page
   

- Advertisement -