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


  • 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




    Tuesday, December 4, 2007 3:06 PM