locked
Execute child package in 32 bit within a 64 bit master package RRS feed

  • Question

  •  

    Is it possible to call a package through the 'Execute package task' and force it to run in 32 bit while the master package runs in 64 bit?
    Tuesday, December 4, 2007 10:55 AM

Answers

  • Yes it is!

    There is a 32 bit DTEXEC.EXE on each 64 bit box.

    You should use a "Execute Process" Task with following parameters:

     

    Executable: C\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe

    Arguments: /file c:\Your 32 bit.dtsx

     

    Regards,

    Thomas

    Tuesday, December 4, 2007 3:06 PM