In SSIS, the data you receive from the source is rarely in the format your end users would like to see. To correct this, you can use the Script Component to transform data. In this demo, Brian shows you how to use the Script transform to make a column proper case in the data flow (free registration required).
http://www.jumpstarttv.com/Media.aspx?vid=6
-- Brian Knight
SQL Server Integration Services checkpoints enable you to start a package from where it failed. This helps you avoid having to re-run a 6 hour package over again. Learn how to use this valuable feature with this quick how-to video (registration required).
http://www.jumpstarttv.com/Media.aspx?vid=5
-- Brian Knight