Showing posts with label location. Show all posts
Showing posts with label location. Show all posts

Tuesday, March 27, 2012

Copy Folders and Files to different location

I have a situation from where I need to loop through different folders and files in these folders. After processing these files, I need to archive these folders to different location.

e.g., C:\MainFolder\Mar01 ==> Multiple files in Mar01 folder

C:\MainFolder\Mar02 ==> Multiple files in Mar02 folder

Does any one know the best way to do this in SSIS?

Thanks in advance.

BC

One way would be a For Each Loop container with Traverse subfolders enabled, with a File System task inside it to move the files once they've been processed.

Friday, February 24, 2012

Copies over links

Hi if I have a backup file in a remote 'US' location of
3gb and I use getright or wget to copy this to a location
in london I want to now add another location Ireland to
copy this file to, will this extend the time of the copy
to london if I want to copy this data to both locations at
the same time. Both locations have separate links to the US
Thanks for any advice
Deanny
Deanny,
as you have separate links, there isn't bandwidth contention. However, there
will be disk useage contention unless you're writing to separate disks which
have separate disk controllers.
HTH,
Paul Ibison