Problem running package

Hi,

I am trying to run simple import export package and if fails saying that pacage execution failed.

then i try using File system and the error say that it is not 32 bit driver and execution failed.

I get this error also

The return value was unknown. The process exit code was -1073741795. The step failed.

thanks

What does your package import/export? If you use 32-bit data providers, you will need to run your package in 32-bit mode.

Thanks.

Problem Related to Package execution in SSIS

Hi,

I have the hierarchy of packages..

there are three levels..

first package (say L1) calls two child packages.(say L2_1 , L2_2)

the parameters are passed to L2_1 from L1 and it executes completely and successfully.

next step is L1 calls L2_2 without any parameters.. and package fails with error as execution of L2_2 failed.

when I executed L2_2 individually it successfully executes.

L2_2 itself calls 5 other packages (at level 3)..

Am not able to identify the possible reason for failure..

I suggest you turn on package logging in each package (right click on the control flow and select logging) and then come back here with specific error messages once captured.|||

Thanks for you help phil...

now I can see the errors due to which my package is failing..

sql