Job Failed due to script task error.

Question

Job Failed due to script task error.

sunnyepgc

Mr or Mrs. 500

Points: 546
More actions
August 31, 2011 at 5:36 am

#242627

Hi,I am getting the below error when i schedule to run my ssis package from production.
Error:The underlying connection was closed: An unexpected error occurred on a receive.
I am not getting the above error if i run the package manually on my production server.Can anyone help me in finding what the reasons and solution for fail job fail...

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

rgtft Hall of Fame Points: 3518 More actions · Answer 1

sunnyepgc (8/31/2011)
Hi,I am getting the below error when i schedule to run my ssis package from production.
Error:The underlying connection was closed: An unexpected error occurred on a receive.
I am not getting the above error if i run the package manually on my production server.Can anyone help me in finding what the reasons and solution for fail job fail...

My first guess would be a permissions issue.

Does the job run okay when you run it on production via BIDs?

What account is the SQL Agent job running under? Does that account have the appropriate permisisons?

Rob

sunnyepgc Mr or Mrs. 500 Points: 546 More actions · Answer 2

The account on which the job has created has admin privilege..Then what might be the other reasons for failure of the package.

sunnyepgc Mr or Mrs. 500 Points: 546 More actions · Answer 3

The account on which the job has created has admin privilege..Then what might be the other reasons for failure of the package.And the package is running good in production with BIDS if i tried to run without job..If i run it with job then failed..

sunnyepgc Mr or Mrs. 500 Points: 546 More actions · Answer 4

Thanks dude ...Your solution worked for me...The problem is with permission for user account..Thanks alot..