Business Intelligence And Data Warehousing Software Directory

SQLDTS Data Transformation Services portal

Details: The Microsoft Data Transformation Services resource portal provides many interesting technical articles and tutorials about Microsoft DTS.
It provides an experts FAQ which shows how to execute DTS packages from a variety of programs such as ASP and Visual Basic and many other tutorials with screenshots, explanations and downloadable source codes and samples.

Among others, the following technical articles topics are worth reading and analysing:
  • Global Variables and Stored Procedure in DTS
  • Example of looping through files in a directory, Importing and loading them
  • DTS Bulk Export Task
  • Global Variables and SQL statements in DTS
  • Execute a package from T-SQL
  • A tutorial on building a Package in the DTS Designer (17 lessons)
  • Example of a task showing how to export all tables in a database
  • Address: