Are you trying to run the report, or preview it (you state "RUN", however, the dialogue says preview, which is confusing)? Generally, with SSRS, you use Preview on a report;...

I really don't know what you're trying to say here I'm afraid.

You need to (probably) provide some sample data here (Saying my data is "like" this doesn't mean...

On it's own, error message 31089 doesn't mean a lot. As you're running this in the SSISDB, the logs will tell you far more information. Have a look at these...

What do you mean my "tried to open"? You don't open a .mdf file, you have to attach it to the Instance. What steps did you take to get the...

SSIS tasks have to be run using Windows Authentication; they cannot be run by SQL Logins. EXECUTE AS does not even get around this; as that is impersonation it's not...

There's no logic to cause that error, that's why. you're setting the value of the error message, but you're not raising one; and your INSERT statement (as far as we...

Also depends what you're trying to do. Developer edition is for, as the name suggests, development. The licence agreement means you can't use it for any production/live work. If you...

Hmm, another interesting tool they've added to SSMS 17.5. SQL Data Discovery and Classification.

Data Discovery & Classification introduces a new tool built into SQL Server...

Little more ugly (well, a lot more), someone might have a better answer, however, this works XML_1_3 logic:

WITH StartEnd AS(
  SELECT t.[TYPE], t.BATCH_NO, t.Xml_name,
   ...

There a lot of guesswork on this, but, perhaps...

WITH Groupings AS(
  SELECT DISTINCT s.ID, t.[TYPE], t.BATCH_NO, t.Xml_name, s.bank, s.[name]
  FROM #temp t
    CROSS APPLY...