Also you cannot have spaces in element names, <Data Extract> needs to be <DataExtract>

DECLARE @SQL NVARCHAR(MAX) = '<DataExtract><Graduates><Candidate><FirstName>Shaun</FirstName><LastName>Slabber</LastName></Candidate><Candidate><FirstName>paul</FirstName><LastName>devine</LastName></Candidate></Graduates><ExperiencedHires><Candidate><FirstName>paul</FirstName><LastName>devine</LastName></Candidate><Candidate><FirstName>Meera</FirstName><LastName>Bhana</LastName></Candidate></ExperiencedHires></DataExtract>'

select @SQL

select CAST(@sql as xml)

What is the output of @sql before you convert it to XML?

DECLARE @sql Nvarchar(max)

SET @sql = '<Data Extract>'

SET @sql = @sql + (SELECT Top 2 FirstName, LastName

FROM

[dbo].[CandPersonal] pe

INNER JOIN CandProfile...

Are you any good in shredding XML? If so, build a second data set which uses the global report name parameter and query the reportserver database for the XML...

You need to ensure that you have set the correct permissions to the folders and reports for the users you want to grant access to.

SSRS is an explicit security system...

Does this happen every day?

If so someone has changed the schedules on all of the subscriptions.

The below will help you find the subscription and then you can troubleshoot from that...

Dumps are in violation of Microsofts NDA which all candidates need to read and accept before taking an exam.

If you are found in breach of the NDA you will lose...

Yes you can do that sort of thing if you want, just need to query the correct tables to get the information out and check it against a previosu run...

sp_msforeachdb also doesnt take into account certain characters in the DB Name, so it wont work as intended if such characters exist. The methods advised of going through sys.databases...

Typically

CH4SQL1\INSTANCE01 runs on CH4N1

CH4SQL2\INSTANCE02 runs on CH4N2

CH4SQL3\INSTANCE03 runs on CH4N3

But as this is a fail over cluster, if each of the Virtual Names wasn't in the 4 nodes XML files...

If you impliment the right security at the login level to prevent people adding people into the role then yes, but remember if a user has sysadmin rights they can...

MSDN - Recovery Models (SQL Server)

Because each instance is a virtual name.

I have 4 nodes and 3 SQL instances therefore I need to have 3 names in the XML file.

CH4N1 - Is a node

CH4N2 -...

Yes, as long as you put TWONODECLUSTER in the XML file on Node1 and Node2

So as you connect to SQL via SSMS as TWONODECLUSTER you put in TWONODECLUSTER in the XML file.

Remember your connecting to MSDB so you need to tell it which SQL...

Check the source where the data is coming from in the package and your transformations, if your inserting a column from the source into the identity column in the destination...