Error en ejecucion de SSIS Package

Hola, intente abrir el paquete con el BIDS o Visual studio para ver si lo
puede ver y ejecutar desde ahi



Maxi Accotto
Microsoft MVP en SQL Server
Consultor en SQL Server



"Jose Luis Cocha" escribió en el mensaje de
noticias:

Tenia ya funcionando un package pero luego de unos dias se presenta el
siguiente error, alguien podria ayudarme a identificar porque se esta
presentando este problema.


Message
Executed as user: BCPDOM\E15927. ...sion 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started:
5:10:27 PM Error: 2009-04-28 17:10:27.59 Code: 0xC0011007 Source:
{BBC9AF4E-EEA0-48D5-B194-BC06CFBB3ECF} Description: Unable to load
the package as XML because of package does not have a valid XML format. A
specific XML parser error will be posted. End Error Error: 2009-04-28
17:10:27.59 Code: 0xC0011002 Source:
{BBC9AF4E-EEA0-48D5-B194-BC06CFBB3ECF} Description: Failed to open
package file "D:\Ejecutable\Dtsx_ComisionesUtilitario.dtsx" due to error
0x80070003 "The system cannot find the path specified.". This happens
when loading a package and the file cannot be opened or loaded correctly
into the XML document. This can be the result of either providing an
incorrect file name was specified when calling LoadPackage or the XML file
was specified and has an incorrect format. End Error Coul... The
package could not be f... The step failed.


Saludos

José Luis Cocha
Especialista TI
Lima Perú

Es un package que esta ya en produccion.

Saludos

Jose Luis


"Maxi" escribió en el mensaje de
noticias:

Hola, intente abrir el paquete con el BIDS o Visual studio para ver si lo
puede ver y ejecutar desde ahi



Maxi Accotto
Microsoft MVP en SQL Server
Consultor en SQL Server



"Jose Luis Cocha" escribió en el mensaje de
noticias:

Tenia ya funcionando un package pero luego de unos dias se presenta el
siguiente error, alguien podria ayudarme a identificar porque se esta
presentando este problema.


Message
Executed as user: BCPDOM\E15927. ...sion 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started:
5:10:27 PM Error: 2009-04-28 17:10:27.59 Code: 0xC0011007 Source:
{BBC9AF4E-EEA0-48D5-B194-BC06CFBB3ECF} Description: Unable to load
the package as XML because of package does not have a valid XML format. A
specific XML parser error will be posted. End Error Error: 2009-04-28
17:10:27.59 Code: 0xC0011002 Source:
{BBC9AF4E-EEA0-48D5-B194-BC06CFBB3ECF} Description: Failed to open
package file "D:\Ejecutable\Dtsx_ComisionesUtilitario.dtsx" due to error
0x80070003 "The system cannot find the path specified.". This happens
when loading a package and the file cannot be opened or loaded correctly
into the XML document. This can be the result of either providing an
incorrect file name was specified when calling LoadPackage or the XML
file was specified and has an incorrect format. End Error Coul... The
package could not be f... The step failed.


Saludos

José Luis Cocha
Especialista TI
Lima Perú

A que llamas produccion? ese paquete buscalo en el proyecto original y
correlo a ver que pasa



Maxi Accotto
Microsoft MVP en SQL Server
Consultor en SQL Server



"Jose Luis Cocha" escribió en el mensaje de
noticias:

Es un package que esta ya en produccion.

Saludos

Jose Luis


"Maxi" escribió en el mensaje de
noticias:

Hola, intente abrir el paquete con el BIDS o Visual studio para ver si lo
puede ver y ejecutar desde ahi



Maxi Accotto
Microsoft MVP en SQL Server
Consultor en SQL Server



"Jose Luis Cocha" escribió en el mensaje de
noticias:

Tenia ya funcionando un package pero luego de unos dias se presenta el
siguiente error, alguien podria ayudarme a identificar porque se esta
presentando este problema.


Message
Executed as user: BCPDOM\E15927. ...sion 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started:
5:10:27 PM Error: 2009-04-28 17:10:27.59 Code: 0xC0011007
Source: {BBC9AF4E-EEA0-48D5-B194-BC06CFBB3ECF} Description: Unable
to load the package as XML because of package does not have a valid XML
format. A specific XML parser error will be posted. End Error Error:
2009-04-28 17:10:27.59 Code: 0xC0011002 Source:
{BBC9AF4E-EEA0-48D5-B194-BC06CFBB3ECF} Description: Failed to open
package file "D:\Ejecutable\Dtsx_ComisionesUtilitario.dtsx" due to error
0x80070003 "The system cannot find the path specified.". This happens
when loading a package and the file cannot be opened or loaded correctly
into the XML document. This can be the result of either providing an
incorrect file name was specified when calling LoadPackage or the XML
file was specified and has an incorrect format. End Error Coul... The
package could not be f... The step failed.


Saludos

José Luis Cocha
Especialista TI
Lima Perú

El problema es el siguiente cuando he instalado para su ejecucion un paquete
que a su vez invoca a 2 package en un servidor no funciona, sin embargo
cuando instalo los 2 package en forma separada y los ejecuto todo funciona
sin problemas.

Cuando intento ejecutar el package que invoca a los 2 package me sale el
siguiente error:

Date 5/21/2009 5:10:30 PM
Log Job History (Todo Ok)

Step ID 1
Server PSQL2K5D01
Job Name Todo Ok
Step Name Todo Ok
Duration 00:02:14
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: BCPDOM\APIVDES. Microsoft (R) SQL Server Execute Package
Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp
1984-2005. All rights reserved. Started: 5:10:30 PM Error: 2009-05-21
17:12:44.49 Code: 0xC002F304 Source: Drop Tables Temporales Execute
SQL Task Description: An error occurred with the following error message:
"The device is not ready. ". End Error DTExec: The package execution
returned DTSER_FAILURE (1). Started: 5:10:30 PM Finished: 5:12:44 PM
Elapsed: 133.875 seconds. The package execution failed. The step failed.

Este package en la portatil funciona muy bien con su respectivo XML de
configuracion que solo sirve para darles la ruta de los otros 2 package.

Saludos y Gracias

Jose Luis



"Jose Luis Cocha" wrote:

Tenia ya funcionando un package pero luego de unos dias se presenta el
siguiente error, alguien podria ayudarme a identificar porque se esta
presentando este problema.


Message
Executed as user: BCPDOM\E15927. ...sion 9.00.3042.00 for 32-bit Copyright
(C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:10:27 PM
Error: 2009-04-28 17:10:27.59 Code: 0xC0011007 Source:
{BBC9AF4E-EEA0-48D5-B194-BC06CFBB3ECF} Description: Unable to load the
package as XML because of package does not have a valid XML format. A
specific XML parser error will be posted. End Error Error: 2009-04-28
17:10:27.59 Code: 0xC0011002 Source:
{BBC9AF4E-EEA0-48D5-B194-BC06CFBB3ECF} Description: Failed to open
package file "D:\Ejecutable\Dtsx_ComisionesUtilitario.dtsx" due to error
0x80070003 "The system cannot find the path specified.". This happens when
loading a package and the file cannot be opened or loaded correctly into the
XML document. This can be the result of either providing an incorrect file
name was specified when calling LoadPackage or the XML file was specified
and has an incorrect format. End Error Coul... The package could not be
f... The step failed.


Saludos

Jos Luis Cocha
Especialista TI
Lima Per