Lots of interesting solutions.
I'd suggest though looking into doing this parsing in whatever is loading the data, so that it is set before it ever enters the database.  
You...

Here's some basic sample code that should get you going.
You'll have to account for edge cases like missing middle initials, extra spaces, prefixes/suffixes, etc...

DECLARE...

Interesting, and definitely not what I expected.
Very curious.

How did you get away without equating your @max-2 variable within your query executed by sp_executesql with the @max-2 variable in your code that calls it?

Ugh, me too.  :pinch::doze:

Revenant (1/4/2017)

Junior Galvão - MVP (1/4/2017)

In tests that I performed the bit in SQL Server Express SP1 2016 the correct answer was the alternative 9:01 (after finish of session 2).

Please...

Iulian -207023 (8/2/2016)

TomThomson (8/2/2016)

It indicates yet another piece of really sloppy human interface design on Microsoft's part. if Foreign Keys on temprorary tables are not enforced, allowing...

I always use a script task to check for the file and set a file name variable. I then add a condition on the connection to the next task...

One of the many reasons I never use this transform.

I do all my data conversion in a Derived Column task, which does let you handle truncation errors by column.

I'm currently using SSIS to load data from various sources into an Oracle database.

You definitely want to use the Attunity providers. They are orders of magnitude faster than the...

Don't use an expression for the default value.

That expression will be evaluated every time the variable is referenced.

So what is happening is that your Expression task...

Like Jez, my initial thought was a package level event handler.

If you are running the package as an SSIS step in a job within SQL Server, you could also look...