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)
 Export txt file to FTP Location

Author  Topic 

smp2001in
Starting Member

2 Posts

Posted - 2008-05-01 : 16:45:41
Hi..I am in a urgent need to know how to export/upload a txt file to and FTP Location, using DTS. URGENT PLEASE.

Thanks
nitin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-01 : 16:47:36
Have you checked out the FTP task in DTS?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page

smp2001in
Starting Member

2 Posts

Posted - 2008-05-01 : 21:00:10
Hey in FTP Task...it only allows to download the file but for the upload of the file that TASK doesnt work..anyother idea pls...
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-01 : 21:45:52
You can run dos command or batch file in dts.
Go to Top of Page
   

- Advertisement -