SSIS scenarios...

One of the most advance feature of SSIS is Script design capability provided be it Script Task in Control Flow or Script Component in Data Flow TaskI have seen people use the Script task pretty often but avoid Script Component because of various reasons.

Earlier I had shown how to set up user variable in Script component.
Shout it
Only $4.95/month – Windows 2008/ASP.NET 4 Hosting!
.