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

Using DTS

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.

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