June 14, 2010 at 4:52 am
Hi when i tried to send file through FTP (using T-Sql) we r getting
when i execute this query
exec s_ftp_PutFile
@FTPServer = 'X.X.X.X' ,
@FTPUser = 'ftptestr' ,
@FTPPWD = 'testftp123' ,
@FTPPath = 'Path' ,
@FTPFileName = 'XXX.doc' ,
@SourcePath = 'C:\ftptest\' ,
@SourceFile = 'XXX.doc.doc' ,
@workdir = 'c:\ftptest\'
the following error
1User (X.X.X.X:(none)): open X.X.X.X:
2NULL
3NULL
4put C:\path.abc.doc
5G:/abc1.doc: The filename, directory name, or volume label syntax is incorrect.
6quit
7NULL
Thanks in advance
Any solution pls
June 14, 2010 at 10:30 pm
hi friends
Instead of ftp can we use Replication if we can use what type of replication is applicable for the task
i read in the the google It is possible in FTP Task using SSIS but
I am new to this SSIS
Please provide the ssis ftp task any screenshots or links
any other solutions pls
Thanks in advance
June 15, 2010 at 10:30 pm
Hi friends
i my self resolved this FTP issue in below the query
exec s_ftp_PutFile
@FTPServer = 'X.X.X.X' ,
@FTPUser = 'abcuser' ,
@FTPPWD = 'abc123' ,
@FTPPath = '' , ---------- here it should be blank path(dont mention path )
@FTPFileName = 'abc1.doc' ,
@SourcePath = 'C:\ftptest\' ,
@SourceFile = 'abc1.doc' ,
@workdir = 'c:\temp'
finally it worked for me thanks
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy