Can you clarify "outputs?" Do you mean as a resultset...

ringovski (1/27/2016)

---

Orlando Colamatteo (1/27/2016)

---

It is still not clear to me what you are trying to do.

Or are you looking to copy data from an XML column in one...

Jeff Moden (1/28/2016)

---

Orlando Colamatteo (1/27/2016)

---

What you have here is a multi-record format where the header line has a different column-format than the data lines. T-SQL solutions traditionally have trouble with...

It is still not clear to me what you are trying to do.

Are you trying to copy data from an XML column in one server to an XML column...

JustMarie (1/27/2016)

---

The desired outcome - open an existing connection manager, run a stored procedure, save the results to a variable, close the connection manager.

I need to send HTML formatted email...

Nassan (1/27/2016)

---

Hello Friends, have sql server 2005 and I'm getting this error message when I write any query or application connects to the Database.

"A system assertion check has...

Please do not duplicate your posts in different forums.

Direct replies here: http://www.sqlservercentral.com/Forums/Topic1756209-146-1.aspx

Not quite following...can you post the table definition and a row of sample data (minus any lengthy binary) to help clarify?

Any reason why you need this procedure to add a column named DUPLICATE to a table, i.e. why is the column not already on the table if it is actually...

You can read about the different deployment models for SSIS, Package and Project, in Books Online.

As for how they get deployed to a production setting, eg by sending to a...

Funny you mention it. I finished migrating the last process that made use of xp_cmdshell in...

I get Kerberos from version 11 (SQL 2012). I do not have version 12 tools setup anywhere at the moment that I could use to test.

Sounds like you need to look into your failover mode settings coupled with your sync mode.

Also, from a data loss perspective are you running in async or synchronous mode...

What you have here is a multi-record format where the header line has a different column-format than the data lines. T-SQL solutions traditionally have trouble with these as hou have...

I think they want to shred the XML column contents in the context of the Package and load the resulting data into standard tables on the downstream.

@ringovski can you...