question

rahulmehta08 avatar image
rahulmehta08 asked

SSIS FTP Connection Manager concatenate the source file name with the windows file server

In my SSIS package, I need to send the file from a windows file server to a linux ftp server. At the source i am using the file connection manager wherein the connection is dynamic i,e connection string is basically Connectionstring = @[User::SourceFileDirectory] + "/" + @[User::FileName] When I see into the destination server the file name is renamed to @[User::SourceFileDirectory] + "/" + @[User::FileName] example:If source directory is //tmp/test and filename is dummy.txt then in the destination(linux server) file name is renamed to //tmp/test/dummy.txt. I have tried passing the variable in source in ftp connection manager and the result is same. And when I am trying using hardcoding the server name or using the local directory as the source then it is running perfectly i.e in linux server only file name is reflected. Anyone have any ideas?
ssisssis2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.