Hi Phil,

Thank you for responding as always. Long story short, I raised this issue with a senior developer on my team that understands the process. I will update this post...

We are going to try SQLXML 4.0. It seems to be what we need. We have one master stored procedure that is calling 15 child procs that all have dynamic...

Full disclosure, I am going on a face to face interview and this is a question that was asked in the phone screen. I would say that a factless fact...

• This reply was modified 6 months ago by Lord Slaagh.
• This reply was modified 6 months ago by Lord Slaagh.

Thank you, Scott!

It still looks better than most of the solutions on Google.

I haven't used STUFF in years!

Really appreciate this!

Hi Jeff,

I am not a huge fan of SSIS myself, but it pays the bills. I will look into the HTML solution, but that would require another step in this...

Hi SSC team,

I wanted to leave the answer here just in case anyone else needs it. This works. Only caveat is that you need to use dts.vaiables instead of what...

Thanks Ken - Thank you very much for your response, but this is just creating an XML table. I need to embed a SQL query into the body of an...

• This reply was modified 8 months, 1 week ago by Lord Slaagh.

This is very helpful for future searches. Thank you Frederico!

• This reply was modified 9 months, 1 week ago by Lord Slaagh.

Hello SSC,

I found it. The execution was in an ETL job that I haven't used before. If anyone else has this issue, try querying the SSISDB. This is how I...

Hi Jeffery,

Responding here for other users with the same issue....

Changing the commit size and row batch worked like a charm! Plus, I dropped the indexes on the table before loading...

• This reply was modified 11 months, 3 weeks ago by Lord Slaagh.

Thank you Jo,

This is very helpful. The recovery Model is set to Simple, so I don't think that is the issue. I will take executing in batches into consideration, the...

Hey Phil,

Thank you. I was missing the plus sign!!! 🙂

It was a silly syntax error!

Thank you all for your answers.

Jeffrey Williams - Thank you so much for the logic and...

Not sure if I posted this on the correct forum. I see an SSIS forum all the way at the bottom of the Forums list. Should I move this? Not...

Thank you, Grant! This was helpful. I did not want to unlike everyone, you guys are great and want to express that!

Hello SSC,

This is strange, I am trying to like these posts, but when I click "like" it sets to "unlike(1)". I do not want to unlike any posts, you guys...