August 3, 2010 at 8:55 am
Hello all together,
i have a problem with a SSIS-Package which i qould start each day with the SQLServeragent.
Their comes this Error:
Ausgeführt als Benutzer: ''NETSERVER2\SYSTEM''. Microsoft (R) SQL Server-Paketausführungsprogramm Version 10.0.2531.0 für 32-Bit Copyright (C) Microsoft Corp 1984-2005. Alle Rechte vorbehalten. Gestartet: 14:20:06 Fehler: 2010-08-03 14:21:42.97 Code: 0xC0029151 Quelle: PDF-Berichte erstellen Task 'Prozess ausführen' Beschreibung: Beim Ausführen von 'C:\Benutzerxxxxx\Firmenxxxxx\xxxxxxxxxxx\xxx\Verarbeitung40\Batch\PDF_ERST.cmd' '' auf 'C:\Benutzerxxxxx\Firmenxxxxx\xxxxxxxxxxx\xxx\Verarbeitung40\Batch' war der Prozessexitcode '1', der erwartete Code war jedoch '0'. Fehlerende DTExec: Die Paketausführung wurde beendet. DTSER_FAILURE (1). Gestartet: 14:20:06 Beendet: 14:21:43 Verstrichen: 96.766 Sekunden. Fehler beim Ausführen des Pakets. Fehler bei Schritt.
In the batchfile PDF_ERST.cmd i will load MS ACCESS 2003 with a MDB which does create some PDF-Files.
If i start the SSIS-Package in the MS Visual Studio 2008 their is all ok and the job starts.
If i create a job in the SQL-Server 2008 then the batchfile will be start, in the taskmanager i see the MSACCESS and then nothing else. I must break the task MSACCESS and no PDF was created.
What is the problem ?? Can anybody help me ???
best regards
g.markus
August 3, 2010 at 9:05 am
Can you translate the error message in English?
August 3, 2010 at 9:21 am
Hello
here is my broken english translation:
Startet as User: ''NETSERVER2\SYSTEM''. Microsoft (R) SQL Server-packageexecutionprogram version 10.0.2531.0 für 32-Bit Copyright (C) Microsoft Corp 1984-2005. all rights ..... Startet: 14:20:06 Error: 2010-08-03 14:21:42.97 Code: 0xC0029151 Quelle: PDFs create Task 'Prozess perform' Description: at execution of 'C:\Benutzerxxxxx\Firmenxxxxx\xxxxxxxxxxx\xxx\Verarbeitung40\Batch\PDF_ERST.cmd' '' on 'C:\Benutzerxxxxx\Firmenxxxxx\xxxxxxxxxxx\xxx\Verarbeitung40\Batch' was the prozessexitcode '1', the awaited code was however '0'. Errorend DTExec: The Packageexecution was finished. DTSER_FAILURE (1). Startet: 14:20:06 End: 14:21:43 Elapsed: 96.766 seconds. Error appears while executing the package. Error at step.
br
g.markus
August 3, 2010 at 10:43 am
The actual error would be in any SSIS package logs that get created, and that path is package-specific. You should look to see if there are any logs being created. If you can execute the package in VS but not as Agent, it most likely is going to be a permissions-related issue with your account having access that the SQL Server Agent does not, or possibly also paths or some such thing. But you need the actual package error to know; all the agent knows is that the package failed.
August 4, 2010 at 1:59 am
Hello Jeff,
the rights seems to be right. The SSIS-Package run direct on the sql-server.
The Package will be start, but the application MSACCESS seems to be hang.
The problem may be that normaly MSACCESS opens a windows an the application
runs. But when i start the SSIS-package with the sql-agent, no windows will be open
and i must break the task in the taskmanager. Also the window which will be open
by the CMD-file does not appear. Under SQL-Server 2000 the MSACCESS-application
runs since many year without a problem and the window of cmd-file and MSACCESS
will be opened. Is their any way to say the sql-agent or any other program, that the
window has to appear ??
If i start the SSIS-package with the DTExec-program it functions without a problem.
Help.....
g.markus
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply