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
 Other Forums
 Other Topics
 file transfer FTP

Author  Topic 

Chinni
Yak Posting Veteran

95 Posts

Posted - 2008-08-28 : 14:19:01
Can you help me in this..

i could not establish connection in FTP task to transfer file to mainframes.

I came to know that this can be done using .bat file.

How can we do this.........can any one guide me regarding this...


Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-28 : 14:27:32
This isn't a SQL Server question, so I'm moving this out of this forum.

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

Subscribe to my blog
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2008-08-28 : 15:23:20
Go to a command prompt, type:

FTP -?

and read all about it.

- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-08-29 : 06:13:18
I would advice you download an ftp software. Try google
Go to Top of Page

Chinni
Yak Posting Veteran

95 Posts

Posted - 2008-08-29 : 15:36:57
i would like to use FTP task in SSIS package
Go to Top of Page

Chinni
Yak Posting Veteran

95 Posts

Posted - 2008-08-29 : 15:38:15
i could not establish connection using FTP task in SSIS so i would like to go for .bat file
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-08-29 : 17:43:20
Well does it work ?
Go to Top of Page

joe.inom
Starting Member

9 Posts

Posted - 2008-09-01 : 10:47:49
well i think FTP wouldnt do good with ssis cause it executes a package from the command line wherever it may be stored. Before running the package, the tool may be instructed to apply configuration information, which will allow the same package to be reused with slightly different parameters, including different connection strings for its endpoints.

joe Alexender
Go to Top of Page
   

- Advertisement -