devxlogo

Using DTS

Using DTS

Why Trust Us

Question:
Is it possible to create a DTS package that does an Update rather than a Select statement?

Also, when I save a DTS package in a file (*.dts as opposed to a repository or in SQL Server) can I view the syntax of the DTS, as in the query analyzer? Does the package use Transact-SQL statements?

Answer:
Yes, you can get DTS to do an update, insert, delete, and select. You can also do creates of things.

I don’t think the DTS internals are available for your perusal, though.

As far as Transact-SQL statements go, it’s kind of a mixed bag. You do write some T-SQL for some jobs, but the data-driven query task (or any transformation really) requires you to use Microsoft Visual Basic for Applications (VBA) as the language.

See also  Why ChatGPT Is So Important Today
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