We have Visual Studio 2012 and SQL server 2012 standard edition.
I have a package which reads data from IBM i-series and populates a table in SQL server. Works fine from SSDT. When I configure this in SQL agent job, I get the following error message.
I have tried to deploy it in SSIS catalog and still get the same error.
Executed as user: YMA\sql2012sa. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5058.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 12:12:55 PM Error: 2015-04-28 12:12:55.27 Code: 0xC0209303 Source: Package1 Connection manager "AS400CA.AS400CA.M_NARAYAN" Description: The requested OLE DB provider IBMDA400.DataSource.1 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2015-04-28 12:12:55.27 Code: 0xC020801C Source: Data Flow Task OLE DB Source  Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "AS400CA.AS400CA.M_NARAYAN" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2015-04-28 12:12:55.27 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: OLE DB Source failed validation and returned error code 0xC020801C. End Error Error: 2015-04-28 12:12:55.27 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2015-04-28 12:12:55.27 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:12:55 PM Finished: 12:12:55 PM Elapsed: 0.25 seconds. The package execution failed. The step failed.