Can you use a single database, put it in azure and add logic around the add some logic around accepting a change

If you are looking to get the relationships between the SFDC objects to apply the same relationships to your SQL tables then you can use the Schema Builder in SFDC...

Set the fixed data property to true

Click on static so its highlighted. Press F4 so the properties window is on the screen and then look for the property i mentioned.

Repeat column headers at the Tablix level only works if you have column groups. Otherwise SSRS doesn't know what text boxes are the header.

What you need to do is go...

Hi,

Yes I use the BIDS helper already and it isn't showing any issues.

It is a view. I will try and add an explicit cast for that...

Most likely a data type mis-match. Check the SQL being generated (it should be available in the details of the processing screen). Column four should be suffixed _4

Just in case you aren't aware the Target Server Version is used by the script task to know what assemblies to call. The fact this was set to 2016 and...