Post reply

job failed while accessing dts package

  • September 7, 2011 at 9:46 pm

    #74232

    Hi,

    we have a job which runs on daily. the job had failed. Then we got the history details.. Could you please help us to investigate further.

    Message

    Executed as user: amet\sql. ...rt: DTSStep_DTSExecuteSQLTask_5 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_5 DTSRun OnStart: DTSStep_DTSExecutePackageTask_1 DTSRun OnFinish: DTSStep_DTSExecutePackageTask_1 DTSRun OnStart: DTSStep_DTSExecutePackageTask_2 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_2; DTSStep_DTSDataPumpTask_1: 0 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_2; DTSStep_DTSDataPumpTask_2: 0 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_2; DTSStep_DTSDataPumpTask_17: 0 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_2; DTSStep_DTSDataPumpTask_15: 0 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_2... Process Exit Code 1. The step failed.

  • September 7, 2011 at 10:15 pm

    #1378353

    This job has worked in the past?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • September 8, 2011 at 2:46 am

    #1378409

    Yes.. The job runs successfully until yesterday.. How can i investigate further?

    Thanks in advance

    Balaji G

  • September 8, 2011 at 9:52 am

    #1378681

    What happens when you try to run the package outside of the job?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 5, 2012 at 2:19 am

    #1428838

    Check if your machine is synchronized with server time and that you are running the job using an admin user,

    otherwise check if admin credentials have been lately changed and if so update login credentials related to the used SSIS proxy.

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

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