July 19, 2010 at 6:05 am
We are trying to execute a perl script from SSIS package using the Execute Process Task. The package calls the same perl script 64 times in parallel, with different parameters.
The package executes smoothly when ran in debug mode through BIDS. But it gets hanged when ran through a scheduled task or a sql server agent job.
When logged on to the server, there are several perl.exe error dialog boxes and perl.exe process in the task manager. Any idea why it gets hanged and why this error?
Thanks.
July 19, 2010 at 6:37 am
Probably a permissions issue relating to the credentials used when the job is executed.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 19, 2010 at 6:46 am
mohsinashfaqh (7/19/2010)
When logged on to the server, there are several perl.exe error dialog boxes and perl.exe process in the task manager. Any idea why it gets hanged and why this error?
Thanks.
Meet us half way - tell us what the error message was.
July 19, 2010 at 8:32 am
An error dialog crops up with the following error:
Perl.exe - Application Error
"The application failed to initialize properly (0xc0000142). Click on OK to terminate the Application"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply