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
1 User (X.X.X.X:(none)): open X.X.X.X:
2 NULL
3 NULL
4 put C:\path.abc.doc
5 G:/abc1.doc: The filename, directory name, or volume label syntax is incorrect.
6 quit
7 NULL
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply