Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Oct 26, 1999

DTS & Data Driven Query Task

Question:
I am trying to import data from a .CSV file and verify that the rec importing does not exist on the destination database (SQL7 DB), then either insert or update the rec's details. But suffice to say this is not happening as I predicted. The insert and update query doesn't seem to be able to translate the field to parameters for the relevant fields.

Any suggestions or samples for doing such a task?

Answer:
I think there is a feature in DTS called Lookup Tables that lets you compare the data in process to the data to reference. It should work as you expect.

If the data in process is not found in the data in reference, go ahead and insert it into the new table, otherwise, skip it.

This is in the data-driven query.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date