Executing DTS packages in 64 bit SSIS

Hello Everyone,

I am going through the following article

http://msdn2.microsoft.com/en-us/library/ms141766.aspx

and I have some clarifications to seek.

Based on the above article it seems its possible to run a DTS package on a SQL 2006 X64 machine.

Furthermore it seems possible that this package will run without any upgrade being performed to SSIS.

Also, to execute the DTS package in 32 bit mode, all I have to do is to set the job step type of SQL Agent to Operating system, and enter a command line or use a batch file that invokes the 32-bit version of dtexec.exe. You can use the dtexecui.exe utility to create the command line, and then copy and paste the command line into the job step.

Are the above deductions correct? Please let me know if some correction / refinement is needed.

There is no 64-bit design-time or run-time support for DTS packages.

You can run DTS packages (SQL Server 2000), as well as SSIS packages (SQL Server 2005), on the same 32-bit machine. You can use the dtsrun.exe utility to run the DTS packages from the command prompt. You also have the option of running a DTS package from a SSIS package (SQL Server 2005) by adding the Execute DTS 2000 Package task to the SSIS package.

For more information about SQL Server 2005 support for DTS packages, see "SQL Server 2005 Integration Services Backward Compatibility" at http://msdn2.microsoft.com/en-us/library/ms143706.aspx#runtime_installing.