Skip to content

DTS

DTS : pre 2005 ; since 2005 : SSIS

  • run your old dts packages using dtsrun
  • 2005 + server : old jobs which were running your dts packages will continue to run.
    ( because the dts runtime environment continues to work. )
  • You can also use “Execute DTS 2000 Package Task” in the SSIS designer to execute your old packages.

==to make changes to old legacy packages, you need the legacy/designer components.==

DTSRun

DTSRun /S {SqlServerInstance} /E /N DouaneExport', @database_name = N'', @server = N'', @database_user_name = N'
dtsrun /Ffilename /Npackage_name /Mpackage_password

INSTALL SQL 2000 DTS package / components on a 2005 SQL

Error message when you try to modify a SQL Server 2000 DTS package in SQL Server 2005:
“The DTS host failed to load or save the package properly”
Article ID : 917406
1) adapt manifest
2) open in SQL 2K ON THE SAME FYS. SERVER AS SQL 2005
3) save
3) import into sql 2005

differences between DTS & SSIS

main architecture
DTS : data into staging tables > transform > pump into destination
SSIS : data into memory > transform > pump into destination
which is much less taxing on the databases