Error when running the package through job RRS feed

  • Question

  • I have created a package from Import/Export wizard and saved the package into SQL Seever. I can able run the package with out any error from integration services ->Stored Package -> MSDB. But when I run the same package through job I am getting the following error.

    NOTE: I am using same user to run manually and agent service.


    Executed as user: xxxx. Microsoft (R) SQL Server Execute Package Utility Version 12.0.4100.1 for 64 bit Copyright (C) Microsoft Corporation. All rights reserved. Started 12:08:59 PM Error 2019-06-07 12:09:01.28 Code 0xC0208449 Source: Data Flow Task 1 Source - Query [80] Description: ADO NET Source has failed to acquire the connection {xxxx} with the following error message: "The type initializer for 'Sap.Data.Hana.HanaConnection' threw an exception.". End Error Error: 2019-06-07 12:09:01.28 Code 0xC0047017  Source: Data Flow task 1 SSIS Pipeline Description: One or more component failed validation. End Error Error: 2019-06-07 12:09:01.28  Code:0xC0024107  Source: Data Flow Task 1  Description: There were errors during task validation End Error DTExec. The Package execution returned DTSER_FAILURE(1). Started: 12:08:59P.M Finished: 12:09:01 PM Elapsed: 1.375 seconds. The package execution failed. The step failed.


    Saturday, June 8, 2019 4:49 AM


All replies