Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 New to DTS. Help Needed very badly!!!

Author  Topic 

Nitu
Yak Posting Veteran

81 Posts

Posted - 2006-01-31 : 15:30:54
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 appreciate you help,

--Nitu

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-01-31 : 15:55:17
Import your data into a staging table. The staging table's DDL should match the layout of the file. Then use T-SQL to do your business rules, meaning to get your data from the staging table to the actual table.

Tara Kizer
aka tduggan
Go to Top of Page
   

- Advertisement -