December 14, 2011 at 2:12 am
Hi,
I have created SSIS Package(SQL 2005) and use operation is "Copy File" but, if i need to copy the whole folder to other folder how operation i would like to use? Thanks in advance
December 14, 2011 at 2:24 am
With whole folder, do you mean all the files in the folder, or do also need to include the directory itself?
You can loop over all the files if you use a ForEach Loop Container. An example can be found here:
http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 14, 2011 at 2:38 am
Hi,
I mean all the files in the folder. Thank you
December 14, 2011 at 2:55 am
thtsps (12/14/2011)
Hi,I mean all the files in the folder. Thank you
Allright, then you should be fine with the ForEach Loop with a FileSystem Task inside.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 21, 2011 at 2:03 am
Thank you koen,
One thing, I'm not sure for 2005 which one about control flow item?
-For Loop Container
-Foreach Loop Container
Please advice. Thanks in advance
December 21, 2011 at 2:24 am
thtsps (12/21/2011)
Thank you koen,One thing, I'm not sure for 2005 which one about control flow item?
-For Loop Container
-Foreach Loop Container
Please advice. Thanks in advance
The second one. Do something for each file in the folder...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply