Sql Server 7 - Dts

Front 1

What is a DTS package? Task?

Back 1

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

Front 2

DTS Task --> send mail

Back 2

send email to a pre-defined mail account

Front 3

DTS Task --> execute process task

Back 3

executes a dos based process

Front 4

DTS Transform property: activeX scripting

Back 4

you can run a column through vbscript(any scripting language) to tweak its contents

Front 5

DTS Lookups

Back 5

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

Front 6

DTS Task --> data driven query task

Back 6

performs a standard transform then runs a query based on the data inserted into the destination (i.e. update a code table)

Front 7

What are DTS transforms

Back 7

they define the movements of data between two datasources. represented by arrows

Front 8

DTS Task --> bulk insert task

Back 8

runs a bcp process

Front 9

DTS Task --> execute sql task

Back 9

executes a single sql statement

Front 10

DTS Task --> active script task

Back 10

runs some activeX script when the task is executed

Front 11

DTS Task --> transfer object task

Back 11

transfers objects between 2 sql servers

Front 12

what is a DTS precedence constraint? 3 types

Back 12

connects tasks together or indicates a transform should occur before or after a task is completed.
1. on completion
2. on success
3. on failure