Transfering Multiple file at a time
Hi I have a multiple file that i want to get from FTP Server to My local Once i receive all file i want to send all to the Different FTP Server In DTS we can get multiple file at same time in same task.But can not do that in SSIS Is there any way by which I can get Multiple File at Single task and also we can Transfer multiple file From Local to Ftp Server.
October 14th, 2010 2:49am

You need to have a ForEachLoop in SSIS and have a FileTaskvinu
Free Windows Admin Tool Kit Click here and download it now
October 14th, 2010 4:33am

You need to have a ForEachLoop in SSIS and have a FileTaskvinu
October 14th, 2010 4:33am

no need to foreach as vinuthan said, you should use MASK for this, in first step which you want to get files from FTP to local, at the end of remote path add *.* with operation as receive file and from local to FTP do same for local path with operation as send filehttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
October 14th, 2010 8:08am

Can you please Elaborate the steps to do that ?
October 14th, 2010 6:55pm

Can you please Elaborate the steps to do that ? Of course, you have two steps: 1- receive files from remote ftp address: add a FTP task, set ftp connection, then go to file trasnfer tab, set Operation as "Receive files" then set localPath to an existing folder as you want, for example: D:\MyTempFolder then in RemotePath set address to remote directory as you want, BUT NOTE THAT YOU SHOULD ADD MASK AFTER IT. for example like this: /myftpurl.com/wwwroot/myRemoteFolder/*.* note that "*.*" means that you want to receive all files from this remote directory. mid step: create new variable of string datatype in package scope, let's name it as LocalPath and set it with your local address but with MASK, for example in our case it will be: D:\MyTempFolder\*.* 2- send files from local directory to remote ftp address: add another ftp task, set ftp connection, then in file trasnfer tab, set Operation as "Send files" set IsLocalPathVariable as True then set LocalVariable with User::LocalPath ( the reason of using variable as localpath is that you can not set localpath directly with MASK, SSIS will raise compilation error. but if you put a variable there and set mask in variable value, SSIS will try to solve it at runtime and everything will work fine) then set remotePath to the remote folder which is your destination, you don't need to add mask here, for example it can be: /mysecondftpurl.com/wwwroot/DestinationFolder That's all. execute it now. http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
October 15th, 2010 9:31am

If i want to receive specific file having specific extention then like i want *.txt and *.csv How can i achive that
October 28th, 2010 2:27pm

HI I also want to transfer multiple files from local path to remote server. I am using FTP Task in For Each Loop container in for each loop container I am mapping vaible to get file name and in FTP task I am using that varibale to get full file name but after package execute it throws error and says "[FTP Task] Error: The variable "User::FullFilePath" doesn't contain file path(s)." this is my variable expression: "(Localpath)"+ "\\" + @[User::FileNames]+ @[User::FileExtension] Variable @[User::FileNames] comes from for each loop container and get file name Variable @[User::FileExtension] = .zip If eveything is right then why it si showing me such error?
Free Windows Admin Tool Kit Click here and download it now
July 1st, 2011 1:47pm

No worries I am done with it it was just a problem with backslash as ssis need one more backslash whaterver we have . I had two backslash in the starting of my file path originally so previously I kept that only but now I put 4 backslashes And Its sending each files to the remote server.
July 1st, 2011 2:09pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics