Copy several files from Server_A to Server_B everyday

Last Post 23 Jul 2009 09:22 AM by ogruizr. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ogruizr
New Member
New Member

--
22 Jul 2009 08:02 AM
Hi all,

I need to copy several files from Server_A to Server_B everyday. Can I do that with SQL Server Integration Service? How can I do that?

Example:

I copy today the following files: file1, file2, file3.
I will copy tomorrow: file4, file5, file6, file7, file8.

and so on.
ogruizr
New Member
New Member

--
22 Jul 2009 01:56 PM
It is not so easy.

Because:

Some files are copied today and tomorrow others.
Files can not be overwritten.
I need to track which files have been copied.
I need to send an email on copy error.

and so on...

ogruizr
New Member
New Member

--
23 Jul 2009 09:22 AM
I was looking for in Internet and I found that I have to use File System Task and ForEach but I don't know how to do it.

Do you have any procedure or document that help me?
You are not authorized to post a reply.

Acceptable Use Policy