Problema con Ejecución de paquete SSIS

[sirguille]

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:

--------------------------------------
 
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
 

[Libras]

parece ser que el primer odbc se esta cargando con un paquete invalido.....

[damimg]

Como estas haciendo la conexion AS400 ? como se denomina el conector? es proporcionado por Microsoft o externo?

Saludos