devxlogo

DTS & Data Driven Query Task

DTS & Data Driven Query Task

Why Trust Us

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  Professionalism Starts in Your Inbox: Keys to Presenting Your Best Self in Email
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

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
View Author
Show More