This is something I don't want to write again...


CASE WHEN DATEPART(WEEKDAY, GETDATE()) = 1 THEN 'Sunday' ELSE
     CASE WHEN DATEPART(WEEKDAY, GETDATE()) = 2 THEN 'Monday' ELSE
         CASE WHEN DATEPART(WEEKDAY, GETDATE()) = 3 THEN 'Tuesday' ELSE
             CASE WHEN DATEPART(WEEKDAY, GETDATE()) = 4 THEN 'Wednesday' ELSE
                 CASE WHEN DATEPART(WEEKDAY, GETDATE()) = 5 THEN 'Thursday' ELSE
                     CASE WHEN DATEPART(WEEKDAY, GETDATE()) = 6 THEN 'Friday' ELSE
                         'Saturday'
                     END
                 END
             END
         END
     END
END AS Today

SSIS: Read/Write Package Variables Inside Script Task

To pull a SSIS Package variable into the Script Task you're working on use this

Dim vars As Variables
Dts.VariableDispenser.LockOneForRead("User::VariableName", vars)

Dim variable As String = vars("VariableName").Value.ToString()

vars.Unlock()

and then use your variable as you need.

To write to a SSIS Package variable in a Script task that you're working on, so future tasks in the package can use it, use the following

Dim writeVars As Variables
Dts.VariableDispenser.LockOneForWrite("User::VariableName", writeVars)
writeVars(0).Value = "Hello World"

writeVars.Unlock()

If you're using a variable to hold a value established in a Script task for use in further tasks, make sure its scope is not limited to just the script task we've made here.

Error On SSIS Package Load

If you ever get:

System.ArgumentException: Value does not Fall within The expected Range.
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String filename, IDTSEvents event, Boolean loadNeutral)...

Make sure you check the string of the package name.