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;
