| Nitu via SQLMonster.com 2006-01-31, 8:23 pm |
| Hi I am a newbie to dts.
I want to perform the follwing steps in a dts package.
1. Connect to ftp server ( I have no problems doing it)
2. download file from the ftp server(done this)
3. transform data in to an existing table, with following rules:
i. check if a similar record exists, then do nothing.
ii. if the record exists with the same unique identifier but,
some of the fields are not similar, then update the current record by
changing one particular field(like date field to capture on which date the
record changed), and then insert a new record in to the table.
iii. If the record doesnot exist at all, then just insert
the new record in to the existing table.
Can somebody please give me some ideas and sample code that you have.
Thanks a lot in advance,
Really appreitiate you help,
--Nitu
--
Message posted via http://www.webservertalk.com
|