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)
 DTS packages failing to connect to moved FTP box

Author  Topic 

Jaybee from his castle
Yak Posting Veteran

64 Posts

Posted - 2007-01-09 : 04:08:21
Hi all,

We've got some DTS packages here that are heavily reliant on FTP to upload files to a fileserver. This fileserver was moved (ie unplugged, hauled out of the building, driven 200 miles and reinstalled), since then the packages have been unable to upload to it.

We have tested connectivity to the box as follows, we have;

pinged it;
disabled it's firewall;
verified connectivity from the fileserver;
updated the global variable in each package that specifies the IP address of the upload server.

But all for naught. Is there anything else we can do?

Thanks,

Jaybee.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-01-09 : 09:23:19
Have you verified that you can use FTP from the system where you are running the packages to connect to the FTP site you are trying to reach?





CODO ERGO SUM
Go to Top of Page
   

- Advertisement -