Estoy tratando de hacer un paquete simple que obtiene data de AS400 y quiero que impacte en una base SQL server.
El paquete se sube al integration services 2008 por managemnet studio MSDB, y se ejecuta mediante un schedulador externo llamado control M, el error que me lanzza es el siguiente:
Código BASH:
Ver original--------------------------------------
Executing package:
\STS\CSF_STS_ActualizarVendedores_AS400_SQL
Package (Package) validation started.
Package (Package) validation completed.
Package (Package) started on 3/11/2014 9:28:30 AM
Task (ObtenerCadena de Conexión) started on 3/11/2014 9:28:30 AM
Task (ObtenerCadena de Conexión) validation started.
Task (ObtenerCadena de Conexión) validation completed.
Task (ObtenerCadena de Conexión) finished on 3/11/2014 9:28:38 AM. Result: Success
Task (Borrar tablas temporales) started on 3/11/2014 9:28:38 AM
Task (Borrar tablas temporales) validation started.
Task (Borrar tablas temporales) validation completed.
Executing query "TRUNCATE TABLE LPTD61TMP;
".
Progress: 50 percent complete.
Executing query "
TRUNCATE TABLE LPTD62TMP;
".
Progress: 100 percent complete.
Task (Borrar tablas temporales) finished on 3/11/2014 9:28:39 AM. Result: Success
Task (Carga temporales) started on 3/11/2014 9:28:39 AM
Task (Carga temporales) validation started.
Information: Validation phase is beginning. Microsoft.SqlServer.Dts.Runtime.TaskHost
Validating
Progress: 0 percent complete.
ERROR: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E44.
An OLE DB record is available. Source: "IBMDA400 Session" Hresult: 0x80004005 Description: "CWBZZ5024 The initial catalog proper\
ty is set to an invalid catalog.".
ERROR: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection \
manager "AS400" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the\
AcquireConnection method call failed.
ERROR: component "AS400_LPTD61" (1) failed validation and returned error code 0xC020801C.
Validating
Progress: 25 percent complete.
ERROR: One or more component failed validation.
ERROR: There were errors during task validation.
Task (Carga temporales) validation completed.
Task (Carga temporales) finished on 3/11/2014 9:28:41 AM. Result: Failure
Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (5) r\
eached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in Maximum\
ErrorCount. Change the MaximumErrorCount or fix the errors.
Package (Package) finished on 3/11/2014 9:28:41 AM. Result: Failure
Package execution completed with 5 error(s) and 1 warning(s).
Package exit message: Failure