April 7, 2011 at 6:39 am
I have not used SSIS a lot other than just for updating tables etc but I have a task which I need help with
I’d like you to create an SSIS package to automate back up archiving
Requirements:
1.Check a designated folder (specified in a global variable) for files changed since last run date.
2.When a new file is available (* see restriction a. below):
FTP the file to a designated server, overwriting the file if already exists on the remote server.
Restrictions/caveats:
a.Files will be created in the folder, but may be locked (still being written to).
The package must cope with this (i.e., ignore) and only FTP files once they are free (the lastUpdateDate of the file will change)
b.The files cannot be moved out of the folder
c.A file uploaded previously may be updated and need to be uploaded again
I am hoping if anyone can let me know how to create a SSIS package. if you need any further details let me know or any blogs which can give me an idea to do the task will be appreciated
Regards,
Netra
April 9, 2011 at 2:38 pm
Duplicate post, direct comments here: http://www.sqlservercentral.com/Forums/Topic1089813-364-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply