December 22, 2008 at 8:56 am
Hi,
I have a problem scheduling a package on the sql server agent 2005.
I ran the package on the dos prompt and it works.
I set credential, proxy and windows account for the sql agent.
But the problem is that when it executes the package, it fails.
Anyone have any clue on how to resolve this for me.
Your help is highly appreciated.
thanks
December 23, 2008 at 8:28 am
Could you provide an error message or the relevant portions of the package log?
December 23, 2008 at 9:07 am
This is the error message on the sql agent. Like I said the package works. But when I ran it in the agent, it didn't work.
SQl Agent:
Date12/22/2008 9:07:51 AM
LogJob History (Load openitem)
Step ID1
ServerP05R5W-LCQCH8C1
Job NameLoad openitem
Step Nameload
Duration00:00:00
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: P05R5W-LCQCH8C1\dbuser. The package execution failed. The step failed.
Dos prompt:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
H:\>c:
C:\>cd TEMP\Integration Services Project1\Integration Services Project1
C:\TEMP\Integration Services Project1\Integration Services Project1>dtexec /f pa
ckage2.dtsx
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 10:05:02 AM
Progress: 2008-12-23 10:05:04.54
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2008-12-23 10:05:05.67
Source: Data Flow Task
Validating: 50% complete
End Progress
Progress: 2008-12-23 10:05:06.82
Source: Data Flow Task
Validating: 100% complete
End Progress
Progress: 2008-12-23 10:05:06.91
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2008-12-23 10:05:07.41
Source: Data Flow Task
Validating: 50% complete
End Progress
Progress: 2008-12-23 10:05:07.41
Source: Data Flow Task
Validating: 100% complete
End Progress
Progress: 2008-12-23 10:05:07.46
Source: Data Flow Task
Prepare for Execute: 0% complete
End Progress
Progress: 2008-12-23 10:05:07.46
Source: Data Flow Task
Prepare for Execute: 50% complete
End Progress
Progress: 2008-12-23 10:05:07.46
Source: Data Flow Task
Prepare for Execute: 100% complete
End Progress
Progress: 2008-12-23 10:05:07.91
Source: Data Flow Task
Pre-Execute: 0% complete
End Progress
Progress: 2008-12-23 10:05:07.91
Source: Data Flow Task
Pre-Execute: 50% complete
End Progress
Progress: 2008-12-23 10:05:07.92
Source: Data Flow Task
Pre-Execute: 100% complete
End Progress
Progress: 2008-12-23 10:05:08.73
Source: Data Flow Task
Post Execute: 0% complete
End Progress
Progress: 2008-12-23 10:05:08.73
Source: Data Flow Task
Post Execute: 50% complete
End Progress
Progress: 2008-12-23 10:05:08.80
Source: Data Flow Task
Post Execute: 100% complete
End Progress
Progress: 2008-12-23 10:05:08.80
Source: Data Flow Task
Cleanup: 0% complete
End Progress
Progress: 2008-12-23 10:05:08.80
Source: Data Flow Task
Cleanup: 50% complete
End Progress
Progress: 2008-12-23 10:05:08.80
Source: Data Flow Task
Cleanup: 100% complete
End Progress
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 10:05:02 AM
Finished: 10:05:08 AM
Elapsed: 6.344 seconds
C:\TEMP\Integration Services Project1\Integration Services Project1>
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply