My output looks different than yours for sure:

I ran the following:

DECLARE @xml XML = '<?xml version="1.0" encoding="utf-8"?>
<SharedDataSet xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition">
  <Description />
  <DataSet...

As a thought, when you ran dtutil.exe, is %f the FULL path to the file or the relative path?  May want to remove the "/quiet" option and just see what...

My preference is before partly because that is what was done before I started and partly because that is my habit from .NET development.

From a C# side, my opinion is...

We should be able to get that value... I don't get it... I changed the XML to be this:

DECLARE @xml XML = '<SharedDataSet xmlns:rd="http://schemas.microsoft.com/sqlserver/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition" >
 ...

Are you using X.VALUE or D.VALUE?  your X.VALUE ones will give you the first result found, the D.VALUE ones will give you one result per row.

Where I work, we do...

I think that really falls into an "it depends" category.

Based on your description, SSIS is likely going to be the best tool.  I would advise against a stored procedure only...

What I meant about capital letters is exactly that. Capital letters in the URL.  SQLServer is not the same thing as sqlserver. Notice the capital letters?

Also, did you try running...

• This reply was modified 5 years, 4 months ago by Mr. Brian Gale.

Michael.leach2015 - you should read Mike01's link.  A lot of people (myself included) do not like downloading random files off of a forum to try to help people.

Drew.Allen did a...

Without a bit more information it is impossible to say.

What does it mean by "stopped allowing connections"?  It could be account lockouts, could be your SQL is not doing authentication...

even with the corrected XML that I put there?

If you run the query I provided in full, it runs and gives you the results you want.

I ran this on SQL...

I think the tool you are looking for already exists in SQL Server - comments.

If the code is difficult to understand, it should be commented.

Failing that, PRINT or SELECT to...

One option that would allow you to continue to control the databases while not presenting it to the client would be to still own the databases.  Host them yourselves or...

This is what you need to add:

  DBType = x.value('(Query/DataSetParameters/DataSetParameter/rd:DbType)[1]','VARCHAR(MAX)'),
  IsMultiValued = x.value('(Query/DataSetParameters/DataSetParameter/rd:IsMultiValued)[1]','VARCHAR(MAX)')

Full query:

DECLARE @xml XML = '<SharedDataSet xmlns:rd="http://schemas.microsoft.com/sqlserver/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition" >
 ...

• This reply was modified 5 years, 4 months ago by Mr. Brian Gale.

for those who want to run this without having to create a table and put the XML into it:

DECLARE @xml XML = '<SharedDataSet xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition">
  <Description...

Have you tested it?  Have the developers tested it?

It falls under "it depends", but, similar to working with ROLLBACK or COMMIT on a transaction.  If you have something like this: