0 Replies Latest reply: Apr 28, 2016 5:44 AM by Ash Tegally RSS

    OLEDB CONNECT Issue

    Ash Tegally

      I have a tab within the load script and the whole report fails as this part fails to connect to the Database. It will connect to the PROMOTION_REDEMPTION__C table in the same Database but wont connect to the CAMPAIGN one.  The Database is a Salesforce SQL Database:

       

       

      OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=vrSalesforceVR1;Data Source=B2CSQL-01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=BIC007033;Use Encryption for Data=False;Tag with column collation when possible=False];


      BATS:
      LOAD distinct promotionRedemptionID,
      ID       as Redemption_ID,
          "REDEEMABLE_CAMPAIGN__C",
          'SF Tagged'       as BATS_Flag,
          "VOUCHER_CODE__C"    as barcode_number,
          "VOUCHER_CODE__C"    as Redemption_barcode_number
          ;
      SQL SELECT promotionRedemptionID,
      ID,
          "REDEEMABLE_CAMPAIGN__C",
          "VOUCHER_CODE__C"
      FROM vrSalesforceVR1.dbo."PROMOTION_REDEMPTION__C";


      Left Join (BATS)
      LOAD ID        as REDEEMABLE_CAMPAIGN__C,
          NAME       as campaign_NAME,
          TYPE;
      SQL SELECT Distinct ID,
      NAME,
          TYPE
      FROM vrSalesforceVR1.dbo.CAMPAIGN;