Steps to recreate the error:
1. Create a new SQL 2000 DTS package or upload an existing package to
Microsoft SQL Server Management Studio ->Management ->Legacy->Data Transformation Services
2. Create a SSIS project which contains a task to “Execute DTS 2000 Package Task”
3. Deploy the SSIS package to SSIS Service on 64bit SQL Server 2005.
4. Test run the SSIS package was successful.
5. Schedule a job to execute the SSIS package on MSDB.
6. At the runtime the job would fail and give the error message below
“This task does not support native Win64 environment. Please run the package in 32-bit WOW environment instead.”
It was known to me that the 64bit SQL 2005 does not have the “Microsoft SQL Server 2000 DTS Designer Components” download available. Only the X86 Package (SQLServer2005_DTS.msi) – 5083 KB is available here:
However the backwards compability component of the SQL 2005 installation does provide the DTSRUN utility, and I was able to run the SQL 2000 DTS package using DTSRUN successfully. Also I was able to execute the SSIS package interactively on the server on step 4 above. I don’t understand why the SQL Agent job would pose a stop on this approach.
0 Comments.