Sql Server 7 – Dts, Top Exam Questions and answers, rated A+. latest update.

Sql Server 7 – Dts, Top Exam Questions and answers, rated A+. latest update. What is a DTS package? Task?--a collection of commands that tell DTS what data to collect and how to write it out to a destination. A package can also contain other commands called tasks which are action statements DTS Task –– send mail--send email to a pre–defined mail account DTS Task –– execute process task--executes a dos based process DTS Transform property: activeX scripting--you can run a column through vbscript(any scripting language) to tweak its contents DTS Lookups--a feature of dts that allows you to define a parameterized query that retrieves a single row and signle column from a data source not participating in the transform. commonly used to translate code values DTS Task –– data driven query task--performs a standard transform then runs a query based on the data inserted into the destination (i.e. update a code table)