DTS Backup 2000 is a tool designed to help with both backup and transfer of DTS packages. The DTSBackup file format and direct transfer of packages between SQL Servers options do not suffer the loss of layout or annotations as you get when the DTS object model. It is of course free to use.

Global Variables and Stored Procedure Parameters   348 Hits

Working with files and the FileSystemObject   251 Hits

Execute a package from Visual Basic (VB)   194 Hits

Transferring DTS Packages   188 Hits

Redistributing DTS with your program   164 Hits

Excel Inserts Null Values   164 Hits

Looping, Importing and Archiving   163 Hits

DTSBackup 2000   139 Hits

Execute a package from Active Server Pages (ASP)   134 Hits

Getting Syntax Help for DTSRun   119 Hits

Converting a DTS Package from Visual Basic 6.0 to Visual Basic .Net   106 Hits

Removing unwanted or orphan connections from a package   105 Hits

SQLDTS File Transfer Protocol Task   102 Hits

Bulk Export Task   101 Hits

How can I check if a file exists?   97 Hits

Global Variables and SQL statements in DTS   97 Hits