Send a file to FTP Server FROM DTS

#1

Hi All,
How can I send(FTP) a file from a DTS Package,
File name changes daily. eg 2004_01_02_Batch.txt

Thanks for your efforts and guidance
Vijay

I Shall overcome

#2

I don't think you can send it from dts.
what you can do is use a little batch file and schedule it using windows
scheduler that will perform the ftp.

--
Regards,

Dandy Weyn
MCSE, MCSA, MCDBA, MCT

www.dandyman.net
"Vijay" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi All,
How can I send(FTP) a file from a DTS Package,
File name changes daily. eg 2004_01_02_Batch.txt

Thanks for your efforts and guidance
Vijay

I Shall overcome

#3

You can also shell out and use the command version of ftp.

--

Andrew J. Kelly
SQL Server MVP

"Dandy Weyn" <mct (AT) dandyman_nospam (DOT) net> wrote

Quote:

I don't think you can send it from dts.
what you can do is use a little batch file and schedule it using windows
scheduler that will perform the ftp.

--
Regards,

Dandy Weyn
MCSE, MCSA, MCDBA, MCT

www.dandyman.net
"Vijay" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message
news:080101c3d148$40f90d20$a301280a (AT) phx (DOT) gbl...
Hi All,
How can I send(FTP) a file from a DTS Package,
File name changes daily. eg 2004_01_02_Batch.txt

Thanks for your efforts and guidance
Vijay

I Shall overcome

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Send a file to FTP Server FROM DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Send a file to FTP Server FROM DTS - 01-02-2004 , 10:51 AM

Re: Send a file to FTP Server FROM DTS - 01-02-2004 , 11:18 AM

Re: Send a file to FTP Server FROM DTS - 01-02-2004 , 12:05 PM