shannon.proctor (3/4/2014)

---

The connection to the data source works fine. This is the issue I'm now having.

I'm running SQL Server 2008 R2 SP2 and I have scheduled other SSIS packages all of which run successfully. I now have a package that contains the Microsoft Connector 1.1 which extracts data from an SAP BW Open Hub. It runs fine in BIDS, but fails when scheduled in a SQL Job with the following error:

Executed as user: EVERPACK\Prod_BIUser. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 10:28:31 AM Error: 2014-03-04 10:28:32.81 Code: 0xC00470FE Source: Customer Master ETL from BW SSIS.Pipeline Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The component "SAP BI Source" (1) cannot run on installed Standard Edition of Integration Services. It requires Enterprise Edition or higher. End Error Error: 2014-03-04 10:28:33.13 Code: 0xC002F304 Source: Failure Send Mail Task Description: An error occurred with the following error message: "Mailbox unavailable. The server response was: 5.7.1 Client does not have permissions to send as this sender". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:28:31 AM Finished: 10:28:33 AM Elapsed: 1.607 seconds. The package execution failed. The step failed.