Fresh Faces, SDK, and Other Support
Except for some new names, the Import/ Export Wizard and command-line utilities remain largely unchanged. DTSRun.exe is called DTExec.exe in SQL Server 2005 DTS. DTSRunUI.exe is called DTExecUI in SQL Server 2005 DTS, and it features a face-lift. We added a new command-line utility called DTUtil.exe that you can use for performing common administrative tasks such as moving, deleting, and copying packages. The utility also performs other tasks such as checking for the existence of packages. In addition, we included a new configuration wizard called the Package Configurations Organizer for creating package configurations, project-development capabilities that bundle a package with its configuration, and a self-installing executable for deploying packages to other machines.
SQL Server 2005 DTS might ship with a software development kit (SDK). However, as of Beta 1, the plan for the SDK is still undefined. Some features you might expect are a task wizard, a transform wizard, and other component-creation wizards. More information about the SDK should be available as SQL Server 2005 gets closer to shipping.
That's the whirlwind tour of SQL Server 2005 DTS. As you can see, most of the concepts remain the same, but the product is brand-new. Indeed, by the time you read this, DTS might even have a new name that reflects that fact.