shannon.proctor (2/27/2014)

---

I have an SSIS package which uses the Microsoft Connector (SAPBI Source) connected to BW. When I try to scheduled the job to run in SQL I get the following error. I am using a proxy to executive the job and I have also created an XML configuration file.

Executed as user: EVERPACK\Prod_BIUser. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 1:47:10 PM Error: 2014-02-27 13:47:10.80 Code: 0xC0014005 Source: Description: The connection type "SAPBI" specified for connection manager "SAP BW Connection" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name. End Error Error: 2014-02-27 13:47:10.80 Code: 0xC0010018 Source: Description: Error loading value "<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:Property DTS:Name="DelayValidation">0</DTS:Property> <DTS:Property DTS:Name="ObjectName">SAP BW Connection</DTS:Property> <DTS:Property DTS:Name="DTSID">{B6CA11CF-7F4D-42AB-930C-67" from node "DTS:ConnectionManager". End Error Could not load package "\CustMast_BW" because of error 0xC0010014. Description: One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors. Source: Started: 1:47:10 PM Finished: 1:47:10 PM Elapsed: 0.078 seconds. The package could not be loaded. The step failed.