SQLDTS.com - Data Transformation Services on the web

Welcome to SQLDTS.com, the Data Transformation Services (DTS) resource on the web. Hopefully there is something here for all levels of DTS user including you.

Most popular articles this month

Working with files and the FileSystemObject 295 Hits

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

Global Variables and Stored Procedure Parameters 292 Hits

Transferring DTS Packages 222 Hits

DTSBackup 2000 140 Hits

Building a Package in the DTS Designer 139 Hits

Redistributing DTS with your program 120 Hits

Getting Syntax Help for DTSRun 102 Hits

Global Variables and SQL statements in DTS 98 Hits

How can I check if a file exists? 97 Hits

Execute a package from Visual Basic (VB) 94 Hits

Looping, Importing and Archiving 94 Hits

How to add a Dynamic Properties task to a package and manipulate it using VB. 74 Hits

Create an Access Database 72 Hits

Excel Inserts Null Values 67 Hits

How to export all tables in a database 67 Hits

What's New

Excel Inserts Null Values 31 May 2005

Multiple Paths in Workflow 1 Nov 2004

Read File Transformation 2 Aug 2004

Global variable diagnostic script 8 Jul 2004

SQLDTS File Transfer Protocol Task 6 Jul 2004

Bulk Export Task 22 Apr 2004

How to export all tables in a database 17 Feb 2004

Global Variables and Stored Procedure Parameters 16 Feb 2004

Getting Syntax Help for DTSRun 19 Jan 2004

Execute a package from a package 12 Jan 2004

(Info...)

Featured FAQ section: Connections

Connections are where our data is either coming from or going to. Some connection types you find in DTS have their own special way of doing things. In this section we address some of those features helping you to produce packages with the minimal amount of fuss. We also look at how to take charge of connections and make them work for you