Error when scheduling SSIS package

• Abu Hafsh

  SSC Rookie

  Points: 49

  More actions

  October 21, 2008 at 11:34 pm

  #131787

  hi everyone,

  I had a problem when i was scheduling SSIS package from MSDB. The error message is shown below... Is there anyone who can help me?

  Btw thanks for the help..

  Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted

  10/22/2008 10:38:00,FACT_DISTRIBUTION_FROM_MSDB,Error,0,PISGA-DW,FACT_DISTRIBUTION_FROM_MSDB,(Job outcome),,The job failed. The Job was invoked by User PARITPADANG\SQLSERVER. The last step to run was step 1 (FACT_DISTRIBUTION_RUNNER).,00:09:35,0,0,,,,0

  10/22/2008 10:38:00,FACT_DISTRIBUTION_FROM_MSDB,Error,1,PISGA-DW,FACT_DISTRIBUTION_FROM_MSDB,FACT_DISTRIBUTION_RUNNER,,Executed as user: PARITPADANG\sqlserver. ...5 Flags=0 ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- _kpedbg_dmp_stack() CALLrel _kgdsdst()+0 149EEFAC 0 +188 _kpeDbgCrash()+49 CALLrel _kpedbg_dmp_stack() +0 _kpeDbgSignalHandle CALLrel _kpeDbgCrash()+0 0 5 1770E988 2 4 2B 4 r()+89 149EF17D _skgesig_Win_Unhand CALLptr 00000000 149EF070 177F3120 ledExceptionFilter ( )+138 7D535407 CALLreg 00000000 78138B5E CALL??? 00000000 ... Process Exit Code -336589910. The step failed.,00:09:35,0,0,,,,0

• hodgy

  SSCertifiable

  Points: 5795

  More actions

  October 22, 2008 at 6:13 am

  #888057

  couldn't make sense of the error message. however, just a quick check: is the account that runs the package a proxy account?

  tom

  Life: it twists and turns like a twisty turny thing