I have developed several SSIS packages with SQL Server Data Tools for Visual Studio 2013. I'm using SalesLogix OLEDB Provider 7.5.4.7048 and the error occurs when the connection is opened. The packages run without error on Win 7 but error on Win 8.

Code:

        bool cancel = false;

        string cnStr = string.Empty;

        switch (Variables.Environment)

        {

            case "DEV":

                cnStr = Variables.ConnectionStringDEV;

                break;

            case "PROD":

                cnStr = Variables.ConnectionStringPROD;

                break;

            default:

                string errMsg = "Invalid Connection String. Check 'Environment' parameter.";

                ComponentMetaData.FireError(10, this.ComponentMetaData.Name, errMsg, "", 0, out cancel);

                LogError(errMsg);

                return;

        }

        cnSalesLogix = new OleDbConnection(cnStr);

        cnSalesLogix.Open(); //ERROR OCCURS ON THIS LINE

Windows error file:

  Problem Event Name: APPCRASH

  Application Name: DtsDebugHost.exe

  Application Version: 2014.120.2000.8

  Application Timestamp: 5306c843

  Fault Module Name: SLXProfiling.dll

  Fault Module Version: 7.5.4.7048

  Fault Module Timestamp: 4def3e71

  Exception Code: c0000005

  Exception Offset: 00005af0

  OS Version: 6.3.9600.2.0.0.256.4

  Locale ID: 1033

  Additional Information 1: 9723

  Additional Information 2: 9723caaff5fe9c9e56d1a9fb81834f6a

  Additional Information 3: 6330

  Additional Information 4: 6330d6491c2e3a183d13684f44ad7e96

thanks for any help in advance!

Will