Job that gets data from DB2 to SQL

• eric200190

  SSC Veteran

  Points: 275

  More actions

  December 15, 2015 at 1:49 pm

  #310266

  I have a job with a DTS that gets data from a DB2 DB to SQL, when i run the job in my pc it runs perfect, but when i run it on the server it gives an error, any ideas of that error?

  I installed Client Access (IBM i access for windows) and im using protection level EncryptSensitiveWithPassword

  Error: Message Executed as user: [UsuarioProxy]. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5058.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 1:10:29 PM Error: 2015-12-14 13:10:32.87 Code: 0xC0202009 Source: P_ActualizarDataLCLW05CSF Connection manager "[Conector]" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "IBMDA400 Command" Hresult: 0x80004005 Description: "CWBZZ5028 An internal error occurred and resulted in return code '32107'.". End Error Error: 2015-12-14 13:10:32.87 Code: 0xC020801C Source: Obtener Max Fecha de la tabla MCP004 e insertar en mcp_control_fecha_db2 OLE DB Source [23] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "[Conector]" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2015-12-14 13:10:32.87 Code: 0xC0047017 Source: Obtener Max Fecha de la tabla MCP004 e insertar en mcp_control_fecha_db2 SSIS.Pipeline Description: OLE DB Source failed validation and returned error code 0xC020801C. End Error Error: 2015-12-14 13:10:32.87 Code: 0xC004700C Source: Obtener Max Fecha de la tabla MCP004 e insertar en mcp_control_fecha_db2 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2015-12-14 13:10:32.87 Code: 0xC0024107 Source: Obtener Max Fecha de la tabla MCP004 e insertar en mcp_control_fecha_db2 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:10:29 PM Finished: 1:10:32 PM Elapsed: 3.261 seconds. The package execution failed. The step failed.

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  December 15, 2015 at 7:24 pm

  #1846235

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5d2ca35a-2e62-40d1-a4ad-091ed1e5a29f/ole-db-source?forum=sqlintegrationservices

  _____________
  Code for TallyGenerator