I was working contract at a place where one person was the lynchpin to several projects.  He was a lead or manager and all of the facts needed to make...

The contents of Text_Value does not look like xml
Can you put this into text?

My recollection is that cross database ownership chaining was on by default in earlier versions of SQL Server and was off by default in later versions of SQL Server.  I...

I don't know if there is a better way yet.  But I found that I could query the catalog.executions view in an Execute SQL task:

SELECT Folder_Name...

I can't say for sure, but I suspect that something is happening when SSIS queries the server for metadata.  Using a SQL Command you have provided the column names that...

I was unable to reproduce the behavior in SQL Server 2016.  Before I dig into SSIS, can you answer a couple questions.  What version of SQL Server are you...

What specifically are you trying to do?  What happens when you try to change the file path that doesn't happen when you change the file name?

I am a developer and have many times been frustrated at hard headed DBAs.

But in the places where they have been the most intransigent, they are also the busiest. ...

You are looking at your problem backwards. You don't want to have a union of two rows of XML. You want xml of a union of two select...

You would just need something like this:

With XMLNamespaces ('namespace' as ns0)

select col as [ns0:col]

from tbl

for xml path

Sorry, since you hadn't responded to my questions about putting it into the SQL, I assumed...

Then it is time to learn XSLT.

Do you have a reason to use ns0 for the prefix? Are you sending data to a tool that does not use a proper XML parser?

I have found it...

A couple thoughts. Where does the XML come from? If it comes from SQL, it would be easy to change the FOR XML to output the namespace.

I would...

That...