Sample Code & Packages

Listed below are the samples from the articles available in the DTS FAQ. Packages are password protected to ensure compatibility across all versions of SQL Server, and the password is "sqldts".

Icon Color Size Tester 20 Jul 2004 A simple icon containing most sizes and color depths for testing icon usage in applications, such as custom task development.	11752 Hits
Job Monitor 5 May 2004 Sample T-SQL implementation of a job monitor system to alert on long running jobs.	19297 Hits
How to export all tables in a database 17 Feb 2004 SQLDTS.com Article: How to export all tables in a database	28603 Hits
How to loop through a global variable Rowset 8 Sep 2003 SQLDTS.com Article: How to loop through a global variable Rowset	23148 Hits
Simple Loop Example 5 Mar 2003 Simple example of looping inside a DTS package.	38207 Hits
Sample Custom Task Project 21 Aug 2002 SQLDTS.com Article: Sample Custom Task Project	22836 Hits
Looping, Importing and Archiving 17 Apr 2002 SQLDTS.com Article: Looping, Importing and Archiving	39500 Hits
Importing a Named Range From Microsoft Excel 6 Apr 2002 SQLDTS.com Article: Importing a Named Range From Microsoft Excel	20742 Hits
FTP COM Object 8 Oct 2001 Simple FTP COM object suitable for use in ActiveX Script Tasks	23036 Hits
Multiple paths in workflow sample package 17 Jun 2001 SQLDTS.com Article: Multiple Paths in Workflow	21082 Hits
Skip the execution of an individual task sample package 26 May 2001 SQLDTS.com Article: Skip the execution of an individual Task	16373 Hits
Execute a package from ASP samples 24 May 2001 SQLDTS.com Article: Execute a package from Active Server Pages (ASP)	24735 Hits
Execute a package from Visual Basic samples 23 May 2001 SQLDTS.com Article: Execute a package from Visual Basic (VB)	27805 Hits
spDTSChangeOwner 19 May 2001 SQLDTS.com Article: Package Ownership Issues	24851 Hits