If you want to "skip" a step, you'll need to have 2 paths to the step *after* the one you want to skip. The flow that goes to the skippable...

Presumably because the prior DML statement was using the opposite data type to what you are now.You're going to...

With the greatest of respect, this won't be true. Someone changed something. Like...

it is weird. I am not sure.

for example the process run last night. the hash that I got from SSIS using the same process we always use that was...

Although the child Package is called from the filesystem, it is also deployed on the SSIS Catalog.

That doesn't make any sense. If the package is deployed in the Catalog you...

It's been on the ask list for Microsoft ever since they introduced the function, but STRING_SPLIT providing the ordinal position of values in the string is something that I really...

Seems like all you need is a few STRING_AGGfunctions:

SELECT DPA.display_plan_id,
       STRING_AGG(PH.promo_id,';') WITHIN GROUP (ORDER BY PH.promo_id) AS Promo_id,
   ...

You could do this in SSIS, but you're likely going to end up using a Script Task or executing a Powershell Script; making the entire point of putting it in...

Here https://sqlperformance.com/2012/07/t-sql-queries/split-strings you have a performance comparison for some methods.

As you can see, the CLR versions have no comparison with the rest. You can build them...

Sorry I could not include the data it was a work project. I've simplified the CTE so now I don't need the lead so everything is working. I am...

I doubt you'll find a solution that is exactly specific to your needs. If you post some sample data (as DDL and DML statements in a code block), and expected...

As you're on SQL Server 2017, why not use STRING_SPLIT?

Without sample data, nor expected results, it's difficult/impossible to give a definitive answer, however, you CAST your 2 date columns to a date in your SELECT but not in the...

Great script!  Thanks.  Used it to create a generic procedure.  Pivoted the data as well.  I'm sure this could be improved on but it is doing the job for...

We're missing a lot of information here. What do you mean by this?

please set sql server system flag 0 to 1

Post the SQL you're actually running. What is the error...