September 20, 2011 at 9:33 pm
Hi buds,
I have an upcoming task with as always tight deadlines. Just to save time and not to reinvent the wheel, I would like to know if any of you have faced the same and have any guidance on this.
Initial setup:
A table with full dump of the data is created in a database.
Requirement:
Download a text/csv file which contains the delta from previous day full share from FTP share to a local drive on a daily basis.
Unzip the file.
Compare the delta to the already existing data in the table using a primary key column.
If there is a match update the row else insert the new row.
I am sure this needs to be handled by a job. But not sure how to proceed.
Thanks for all your help in advance!
September 21, 2011 at 1:07 am
I'd take a look at SSIS (MS Sql Server Intergration Services). With a script task for the zip/unzip of files, you should be able to easily automate your requirement.
Try http://msdn.microsoft.com/en-us/library/ms169917.aspx as a starting point!
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply