October 5, 2007 at 10:32 am
I will be receiving groups of files (with different names each day). I need to open each of these files and suck the contents (XML) out and into a column of a database table. I would also like to grab the file name if possible (for another column as audit trail).
These files are coming in via FTP and will be unzipped and de-encrypted before this process. I would love to make this server code and not an application. Any ideas?
SB
October 5, 2007 at 11:36 am
XML Files, batch import, different names, picked up from an FTP site.
SSIS will do all of this and allow you to schedule the job from the server to make it completely automated.
There are plenty of other ways, but if you have not worked with SSIS before, now is the time to grab a book and get into it.
October 8, 2007 at 11:11 am
SSIS gets my vote as well...
If your FTP server is robust enough, let it drive the workflow. Otherwise, build a simple .NET service to watch the incoming FTP directories, unzip/unencrypt the files, and then kick off your SSIS package using the DTExec.exe utility.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply