Job created in SSIS does not work in SQL SERVER AGENT

Navigation
1

I have a job created in SSIS (working perfectly) that does not work in SQL SERVER AGENT. The job extracts some data from an access table, via ODBC, and loads into a sql server local table. The Sql Server and the access database are on different servers, both with x86 framework. I put both the job in SQL Server and the SSIS configuration to run on x86, but I still can not run the job on the Sql Server Agent.

Below the error shown:

  

01/14/2016 12: 49: 15, load_hlr_join_atem, Error, 1, W7RJO071543, load_hlr_join_atem, Exec Package , Executed as user: EMBRATEL \ EGSANTO. Microsoft (R) Package Execution Utility SQL Server Version 11.0.5058.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Start: 12:49:15 Error: 2016-01-14 13:06:34.12 Code: 0xC0014020 Source: Package Manager "TB_HLR" Description: ODBC Error -1. Error End: 2016-01-14 13:06:34:13 Code: 0xC0014009 Source: Package Manager "TB_HLR" Description: An error occurred while trying to establish an ODBC connection to the database server. End of Error Error: 2016-01-14 13:06:34:13 Code: 0x0000020F Source: Task Data Flow NeFone (Access) [67] Description: Failed to call AcquireConnection method for connection manager TB_HLR with error code 0xC0014009. There may be error messages posted before this with more information about why the AcquireConnection method call failed. End of Error Error: 2016-01-14 13:06:34:13 Code: 0xC0047017 Source: Task Data Stream SSIS.Pipeline Description: NeFone (Access) validation failed with error code 0x80004005. End of Error Error: 2016-01-14 13:06:34:13 Code: 0xC004700C Source: Task Data Stream SSIS.Pipeline Description: Validation failed for one or more components. End of Error Error: 2016-01-14 13:06:34:13 Code: 0xC0024107 Source: Task Data Flow Description: There were errors during the validation of the task. End of DTExec Error: The execution of the package returned DTSER_FAILURE (1). Started: 12:49:15 Conclusion: 13:06:34 Elapsed time: 1038.37 seconds. Package execution failed. The step failed., 00: 17: 19,0,0 , 0

Could you please help me with this problem?

Thanks in advance for the help!

    
asked by anonymous 14.01.2016 / 17:03

2 answers

0

I wrote the same one that was indicated in Rodrigão's comment in his stackoverflow.com question.

link

    
14.01.2016 / 18:04
1

When you run it through Visual Studio does it work correctly? If so, it is likely that it does not have the 64-bit version of the access driver installed on the server. (this is from 2010, download the corresponding version of your access). link

Verify that the 64-bit drivers are installed. If you can not check or you do not have access to it, try running the job by checking the "32-bit-runtime" option in the "Configuration / Advanced" tab of JOB in SQL Agent.

    
14.01.2016 / 17:36
Error adding fields to Text Edit using OnFocusChangeListener Data format php pdo [duplicate]