devxlogo

DTS & Data Driven Query Task

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.

See also  Redefining Energy Management: Advanced Solutions for Modern Buildings
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist