Post reply

SQL Job is getting failed in half the way

  • March 9, 2010 at 10:08 pm

    #99116

    Hi,

    I have a ssis package which execute through sqlagent job.Here the package executes well and good without any error in ssis environment,but if i try the same through job then it is getting failed that too in between ( means - data is getting populated in fact tables and next to that there is aggregate sequence container is avail,its not populating data in that aggregate table)

    I have captured the error in log and it shows that error in that sequence container.Point to be noted here is,i can very well execute the package in ssis environment.So am totally confused.

    I checked that there is no access problem,Its simply show error in that sequence container.

    Kindly help me out in this issue.

  • March 9, 2010 at 11:54 pm

    #1131156

    Can't even start to help you. Please post the complete error message you are receiving when the SSIS package is run as a scheduled job.

  • March 10, 2010 at 5:11 am

    #1131270

    Hi,

    i have an onerror event handler for that sequence container ...when the job is executing that onerror event handler fires and writes the error

    (Logoutput

    This Staging sequence Container failed for Proj_Resource_Details20100219.xls for user CHENNAIODC\286581 from server INFCH02379 on2/19/2010 10:54:42 AM

    )

    in the log file.

    If i execute the same through ssis environment then it was finely executed. Moreover before that sequence container i have two container,that containers table all got populated and job failed in half the way..

    Give me your suggestion ... Thanks in advance...

Viewing 3 posts - 1 through 3 (of 3 total)

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