Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error when scheduling SSIS package Expand / Collapse
Author
Message
Posted Tuesday, October 21, 2008 11:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 20, 2009 3:00 AM
Points: 1, Visits: 23
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
Post #589590
Posted Wednesday, October 22, 2008 6:13 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 6:06 AM
Points: 1,865, Visits: 594
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
Post #589741
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse