i am extracting data from db2 using 32 bit provider using ssis (32 bit setting and set up job (32 bit mode) on a 64 bit sql server. the ssis execution crashes with visual studio and dtexec, succeeds through dtexecui, please let me know how to troubleshoot the issue. the job fails when run using sql agent with error, proces exit code 255, please help. thanks nik

you can check the "Run 32 bit Runtime" in execution tab of job step or you can use direct DTEXEC command line where the dtexec file comes from this address: <program files x86>\microsoft sql server\100\dts\binn\dtexec.exe this is address of 32 bit dtexechttp://www.rad.pasfu.com

thats exactly what iam doing, the application crashes in both cases, visual studio execution (run 56 bit to false) or through dtexec using x86, in both cases, the execution utility crashes, the pacage only succeeds thru dtexecui, why whats different the job (akthough 32 bit run time is selected,) gives error everytime, exit code 255. please guide

there should be another problem did you tried to run DTEXEC command from Command prompt? use dtexec.exe from program files x86 and run the command directly in command prompt. let us know what error do you receive?http://www.rad.pasfu.com

i did that, the data transformation execution utlity stops working after the validation phase, although i use x86, the only thing that succeeds in the dtexecui,

i did that, the data transformation execution utlity stops working after the validation phase, although i use x86, the only thing that succeeds in the dtexecui, do you received any error? if yes, put error message herehttp://www.rad.pasfu.com

the error when i execute through dtexec says data transformation execution utility stopped working in the application event viewer i see that dtexec application crashed, it creates a error dump somewhere, event viewer has the following everytime dtexec is used to execute or visual stuidio is used Fault bucket , type 0 Event Name: APPCRASH Response: Not available Cab Id: 0 Problem signature: P1: dtexec.exe P2: 2009.100.2500.0 P3: 4dfb1355 P4: StackHash_972d P5: 6.1.7601.17514 P6: 4ce7ba58 P7: c0000374 P8: 000ce653 P9: P10: Attached files: These files may be available here: C:\ProgramData\Microsoft\Windows\WER\ReportQueue\AppCrash_dtexec.exe_26edf0ae80e9816aaf8eb087e26622f85bea5_001622ba Analysis symbol: Rechecking for solution: 0 Report Id: 5f6cf9c9-2d89-11e1-afb3-0050568b002c Report Status: 4 Faulting application name: dtexec.exe, version: 2009.100.2500.0, time stamp: 0x4dfb1355 Faulting module name: ntdll.dll, version: 6.1.7601.17514, time stamp: 0x4ce7ba58 Exception code: 0xc0000374 Fault offset: 0x000ce653 Faulting process id: 0x860 Faulting application start time: 0x01ccc196202b404f Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\100\DTS\binn\dtexec.exe Faulting module path: C:\Windows\SysWOW64\ntdll.dll Report Id: 5f6cf9c9-2d89-11e1-afb3-0050568b002c and the same package works through dtexecui. the sql agent job fails with exit code 255, unknown return value error messag

Hi neophytenik, Please refer to the similar threads in the following links: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/aa29a8d3-d7ca-43e6-9266-b2f45dfdf3cd http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a07add15-29ae-4a68-bde6-701b23b651cb/ Thanks, Eileen

Hi neophytenik, Please refer to the similar threads in the following links: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/aa29a8d3-d7ca-43e6-9266-b2f45dfdf3cd http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a07add15-29ae-4a68-bde6-701b23b651cb/ Thanks, Eileen