Importing/Exporting Data  «Prev 

DTS Package Designer used in SQL Server

DTS-Designer
DTS-Designer

  1. WorkFlow menu – The WorkFlow menu allows you to define a transformation from one or more data sources to a destination. You can also specify what to do on completion of a task for failed tasks, completed tasks, and successful tasks.
  2. White area of the screen – The Design sheet will graphically show you the package you are working on.
  3. Task and icons under it – The Tasktool bar lists the standard tasks that can be performed.
  4. Data and icons under it – The Datatool bar lists the common data types