Here's a possible workaround. Note that this will prevent the use of index seeks.

CREATE TABLE #Sample(
  DecoderCode varchar(20))
INSERT INTO #Sample
VALUES( '4294967296'), ('8589934591'), ('7220817'),...

The problem is that you're only leaving letters and numbers instead  of all non-unicode characters.
The following function uses several techniques such as a tally table,and using FOR XML to...

The problem is that you're coding in T-SQL and SSIS uses a different language for derived columns.
Here's a formula you can use:

(DT_DBTIMESTAMP)((DT_WSTR,4)(OrderYearMonth / 100) +...

Summarizing (and correcting) the options:

SELECT YEAR(GETDATE()) YEAR,
   CAST(DATEADD(dd, -1, DATEADD(yy, DATEDIFF(yy, -1, GETDATE()), 0)) as date) LastDayofYear,
   CONVERT(date, DATENAME(YEAR,GETDATE())+'1231'),
   DATEADD(yyyy, DATEDIFF(yyyy, 0,...

Obviously, the column names were changed, but I left the length exactly the same.
Several pork-chop airstrikes where ordered for this.
I'm not sure if data types are subject...

So, today I got this beauty for deployment. Things like these make me want to either slap or choke the developers.

CREATE TYPE [dbo].[udtbl_ParentSomeColumnXXID_ParentSomeOtherColumnXXID_ChildSomeColumnXXID_ChildSomeOtherColumnXXID_FlipFlag] AS TABLE
( 

Why are you even using a loop? Why don't you do it in a single execution? What changes?

What about creating a function that would run 5 times faster?

CREATE FUNCTION ifn_TruncateOrRoundDatetime(
  @Datetime datetime,
  @DatePart char(2),
  @Truncate bit
)RETURNS TABLE WITH SCHEMABINDING