Hello Evereyone, I have a folder in server1 and in that folder i have 10 files now i want to transfer this folder to another server2. I have used foreach tools inside it i have used file system task.I have done all the configuration properly . Problem is comming when i am runnin my package its giving error and when i check the folder in server2 only 1 file is there inside the folder. I think its copying only 1 file because its giving me error that file1 already exist in server2 folder can any one provide me some solution or suggestions or links .

What is the error message-------------------------------------------------------- Surender Singh Bhadauria

File already exist error is comming. but there is no file in server2 folder as i have mentioned above. can u provide me some links or suggestion where this type of example is given. Hope u understand my problem. Simply i want to copy my folder which contains 10 files in it from server one to another another server two

Check the variable that has the file name most probably it is still having the earlier file name that's why it is throwing that error and try keeping the Overwrite destination to true and run the package and check the contents of the file after transfer to verify which file was it-------------------------------------------------------- Surender Singh Bhadauria

thanx surender for ur help Still the same problem is comming can u provide me some examples or link please provide solution for this problem

Hi Aiay Singh Rawat, Please refert to the simlar thread as below, and check if it works for you. problem comming in For each Loop in SSIS: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/99fee59f-d45f-4aef-9a8f-9fbff9cd8a70 If you have any question, please feel free to ask. Thanks, Eileen

This problem can be solved so much more efficiently in .NET. You got to choose the right tool for the right job. SSIS is all about moving and manipulating data, not about file management. In .NET you can solve this easily by using the DirectoryInfo.GetFiles() method, a loop and the Move command.MCTS, MCITP - Please mark posts as answered where appropriate.