Migrating DTS package to SSIS

[rais0921]

Hi There,
We are upgrading to 64Bit OS and SQL 2005 server. I have migrated a DTS package which includes Activex Script task to SSIS. I built a SSIS package using "Execute DTS 2000 package Task" and put that DTS package inside it. Once I ran the SSIS package in BIDS it ran Ok, but it gave me an error, "package needs to run under 32 bit mode......", when I tried to run as a job. I changed the Package property>debugging>Run64bitruntime>false but it did not work.

This package was created in 32bit mode by the previous developer.

I would highly appreciate if anyone helps me on this matter.

Thank you in advance for your time and support.

 

[Viass]

To execute your SSIS package in 32-bit mode on a 64-bit OS
you need to run your package using DTEXEC or its GUI-counterpart,DTEXECUI.exe.

The 32-bit version of dtexec.exe is located
at Program Files(x86)\Microsoft SQL Server\90\DTS\BINN\dtexec.exe.

Invoke dtexec.exe within a batch file or command line.

 

[SQLDallas]

Hi Viass,
Thank you so much for your help. It worked perfect. Now I can run the package as a scheduled job.

I appriciate your time and effort.

Thanks,