Or upload it to Paste the Plan and share the link.

So, I am actually doing the high level package review, where I want to rule out if the code snippets can be optimized in any way. So, I got...

Thank you, Thom,

That is precisely what I need as per my sample data.

Now I have one more further question. As you know, the data will not always clean or...

I had thought to use PARSENAME here, however, they all return NULL. You can achieve this with a few CHARINDEXs though:

SELECT tp.id,
     ...

Guessing non-existant as they're still...

jameishwartions is competing with them now too. >_<

Possibly. But I didn't want to force Phil to wait for any article I did write to be published. 🙂

I was half expecting/hoping that there would at...

Any admins about to ban https://www.sqlservercentral.com/forums/user/james500 ? He's spammed over 50 topics in the last hour with advertisements for counterfeit documents.

I've done similar things. I tend to use a Expression task instead, but same idea. I don't think there is anything you can natively do. Seems that Microsoft expect you...

Was worth a go. I've been struggling to install it, as the office's firewall is a real pain; it has to scan every file you download (in full) before you...

If it helps, I've found the package on NuGet: https://www.nuget.org/packages/System.Management.Automation/

Clients, managers, "the business" ask us to do odd things all the time, the impoprtant thing though is to...

Hadn't noticed that tiny, side note at the end (feels like it should have been made more obviously).

I never, however,...

we are in the process of deploying the packages to an integrated environment

What do you mean by that, as in deploying them to SSISDB? Are the packages all in the...