question

SSGC avatar image
SSGC asked

ssis package call child ssis package use DTExec command

I have a SSIS package A can run fine in a 64bit machine, I have another SSIS package B will generate a 97-2005 Excel file. After I set Run64BitRuntime to false, it also can run at a 64 bit machine. Now I need use package A to call package B use DTExec command with parameter pass from package A to B. I got failed. If I use Program Files (x86) DTExec utility it is fine, but I cannot use DTExec under Program Files. on our production server there are no 32 bit DTExec installed. Could someone help me for this issue? is it possible to use 64 bit DTExec run a 32 bit package B? Thanks.
ssisdtexec
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Shawn_Melton avatar image Shawn_Melton commented ·
Why not use SSIS Execute Package Task? http://msdn.microsoft.com/en-us/library/ms137609.aspx
1 Like 1 ·
SSGC avatar image SSGC commented ·
The parent package A did by someone else in production and many agent job use it, we try not change it. If we can change package A, we have many different choices. Thanks.
0 Likes 0 ·
SSGC avatar image SSGC commented ·
Does someone can help me to solve this issue? Thanks!
0 Likes 0 ·

1 Answer

·
eaglescout avatar image
eaglescout answered
According to what I've read, it is not possible, sorry. Please read this article: http://help.pragmaticworks.com/dtsxchange/scr/FAQ%20-%20How%20to%20run%20SSIS%20Packages%20using%2032bit%20drivers%20on%2064bit%20machine.htm
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.