SSIS Variables

This can be used to insert Package name and run date into a package history table.

"INSERT INTO PackageHistory (PackageName,RunDateTime) VALUES (' " + (DT_wSTR,50) @[System::PackageName] + " ',GETDATE())"