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;