Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key


Play button


Play button




Click to flip

12 Cards in this Set

  • Front
  • Back
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)
What are DTS transforms
they define the movements of data between two datasources. represented by arrows
DTS Task --> bulk insert task
runs a bcp process
DTS Task --> execute sql task
executes a single sql statement
DTS Task --> active script task
runs some activeX script when the task is executed
DTS Task --> transfer object task
transfers objects between 2 sql servers
what is a DTS precedence constraint? 3 types
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