Content is the column name and the value is being returned but what is getting returned looks something like this instead of one row with the appropriate value in the...

We've figured it out. We have some embedded queries that aren't stored procedure calls because we don't have the privilege to store a proc on the source server. Some of...

It's not a permissions problem. I'm accessing the database using the sa account. (Not my preferred method but I lost this battle. In this case it helps rule out a...

No, that's not what I said at all. The proc always works, including in SSIS, except in one scenario. I apologize for the misleading subject.

The scenario is that...

I'm getting the error from an SSIS package so I referred to it that way in the title. There's nothing wrong with the proc either. That's kind of the point....

Just to reiterate. It is not a problem with the connection string. There are absolutely no extra semi-colons and it has been checked 100 times at least. In fact, it...

If you're confused, I'm even more confused. I made a change in the copy of the stored procedure in my database project and I thought, when I posted, that I...

That's actually the way it is in my code except for the insert and select statements which are one line. Of course, I chose the wrong tag...

Sorry about that...

It...

Eirikur Eiriksson (11/15/2016)

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @TXML XML = '<pllog>

<log>

<datetime>20151021183108</datetime>

<ms>900</ms>

<type>Info</type>

<action>RES ONE Workspace initializing</action>

<result>Version 9.10.0.1</result>

</log>

<log>

<datetime>20151021183108</datetime>

<ms>900</ms>

<type>Info</type>

<action>Session GUID</action>

<result>{6E332C48-207F-4619-A25C-2B8716A19E31}</result>

</log>

<log>

<datetime>20151021183109</datetime>

<ms>134</ms>

<type>Info</type>

<action>TS client name</action>

<result>LAPTOP-HEV</result>

</log>

</pllog>

'

SELECT

XLOG.DATA.value('(datetime/text())[1]' ,'VARCHAR(50)' )...

Create a new table based on the node, with new columns based on the elements dynamically. In this example, a new table called Log with columns: datetime, ms, type, action,...

My objective is to shred it and store the data in tables dynamically. If that isn't possible then I guess I'll be forced to hard code for certain tags.

I haven't ruled anything out but I'm not sure how Xquery can help me when I don't know what is in the XML at the time I'm trying to shred...

It's kind of a broad question but ultimately depends on what constitutes "business logic". I generally fall on the side that says databases should be stupid and do what they're...