Importing/Exporting Data  «Prev 

DTS Designer tasks in SQL Server

DTS Package Tasks consisting of Active Script Task and Execute Process Task
DTS Package Tasks consisting of Active Script Task and Execute Process Task

  1. Active Script Task – The Active Script Task allows you to define a Visual Basic ActiveX script or Java ActiveX script to be executed.
  2. Execute Process Task – The Execute Process Task allows you to specify a process to run, the processes parameters, and the processes successful return code.
  3. Execute SQL Task – The Execute SQL Task allows you to specify any SQL to execute. You can also call the Query Designer from here to graphically design a query.
  4. Data Driven Query Task – The Data Driven Query Tasks allows you to transfer data from one data source to another, either moving data from a table or moving data based upon a query.
  5. Transfer SQL Server Objects Task – The Transfer SQL Server Objects Task allows you to transfer all objects from one SQL Server 7.0 database to another SQL Server 7.0 database.
  6. Send Mail Task – The Send Mail Task allows you to send email as part of a package.
  7. Bulk Insert Task – The Bulk Insert Task will perform a bulk insert of a text file into SQL Server 7.0 or greater.
  8. Microsoft OLE DB Provider for SQL Server data object, The Microsoft OLE DB Provider for SQL Server allows you to specify an OLE DB connection to SQL Server.
  9. Microsoft Access data object – The Microsoft Access data object allows you to specify a connection to a MS Access database.
  10. Microsoft Excel 8.0 data object – The MS Excel 8.0 data object allows you to specify a connection to a MS Excel file.
  11. dBase 5 data object – The dBase 5 data object allows you to specify a connection to a dBase 5 database.
  12. Paradox 5.x data object – Paradox 5.x data object allows you to specify a connection to a Paradox 5.x database.
  13. Text File (Source) data object – Text File (Source) object allows you to specify a read connection to a text file.
  14. Text File (Destination) data object – Text File (Destination) object allows you to specify a write connection to a text file.
  15. Microsoft ODBC Driver for Oracle data object – Microsoft ODBC Driver for Oracle object allows you to specify a connection to an Oracledatabase.
  16. Microsoft Data Link data object – Microsoft Data Link data object allows you to specify a connection to OLE DB resource.
  17. Other Connection – The Other Connection data object allows you to specify a connection to an ODBC data source