April 7, 2011 at 6:25 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 7, 2011 at 7:25 am
In my humble oppinoin I would suggest that SSIS is likely not the best way to handle this process.
SSIS is not a file management system. While SSIS does have tools that would allow you to see file properties and such the only way I would think you could accomplish you goal would be through heavy C# or VB scripting. SSIS simply does not have the resources nativly for file management. I have not been on the IT administration side of the desk for a while but I used a free app that I had found that would do what you are describing. There are also VB scripts that can be found out there. Fo that matter you backup software may very well be able to do what you are looking for.
I am not saying it could not be done in SSIS as I beleive it could through the C# and VB script components but I would have to beleive there are better solutions out there for file management than SSIS.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 8, 2011 at 9:28 am
I agree with Dan. I categorize this kind of work into the sysadmin domain which is not a strength of SSIS.
What you've described is a need to sync a local directory with a remote FTP directory on a regular basis. I see a couple options:
1. Homegrown: coding a script in PowerShell that uses the basic command line FTP client included with Windows could handle the task nicely
2. Third-party: Globalscape CuteFTP Pro is $89.99 and supports scheduled FTP transfers which will do exactly what you're looking for. It can sync a local directory and remote FTP directory and will tolerate open file handles.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply