Hello!

Please check following link:

http://www.sqlservercentral.com/blogs/dknight/archive/2009/12/11/running-ssis-32-bit-drivers-or-tasks-on-a-64-bit-machine.aspx

This is an example of running SSIS package in the 32-bits mode from SQL stored procedure:

DECLARE @result INT,

@dtsExecCmd varchar(8000)

-- Assign values to package variables

-- @pNumber...

Very helpful, thank you very much!

Sergey