I agree that this is a great solution and some fine "out of the box" thinking for SSIS.

My problem with it all though is, you already know what the definition...

Peel one potato at a time.  Like Ratbak suggests above, it will require a "Diligent Data Engineer".  One of the best things to make as you go along, is a...

IMHO... that's what the word has come to mean but not for me.  You can have all the tools...

I'm thinking that they've stretched Steve a bit too far... I can't even get an acknowledgment to the two emails that I've sent the WebMaster about the email notifications.

I guess DevOps has degraded to the point where you can't even get an acknowledgement to a site problem sent to the WebMaster because there's too much DevOps going on,...

This isn't the place to post an article.  This is a thread for people to request articles or post article ideas.  Hopefully, though, the WebMaster will see this and respond...

As a bit of a sidebar, you may have some people come back with a suggestion of using the built-in STRING_SPLIT() function.  That will seem to work but...

At McFarlandParkway,

Are you all set?  Did the solution I posted work for you?

@Sathish,

Are you all set?  If not, take a look at the article at the first link in my signature line below to learn how to post some "Readily Consumable Data"...

@Tobar... did you ever figure this out?  Without being able to put my hands on the database, I'm out of suggestions.

Assuming that all of the other 20 subqueries are based on the same pattern in tblPolSpec, you will probably get better performance if you use a CROSS-TAB query like...

Many thanks for your help. I have been told that it uses DTExec.exe to run the SSISpackage. I am trying to find out more about this but if anyone...

Memory optimized?

The original code looks like a "poor man's CROSSTAB".  Try the following true CROSSTAB instead.

 SELECT  PolNr = m.PolNr
       ...

Thanks for the reply, Eirikur.