Here is a neat guide provided by SearchSqlServer.com on maintaining DTS packages in SQL Server 2005 - http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1251587,00.html

I have not tried out the component yet, but this looks like something with *HUGE* potential. May be this will ease the burden of parsing data from the free-flow text reports generated by legacy apps. Anyone who has tested the component and stumbles upon here is requested to leave some comments on the...

I had always wondered whether it would be possible to write the Script tasks we use in SSIS in C#. Finally, this post from MSDN forums cleared that up.Apparently, Script Tasks use VSA and VSA supports VB.Net only. Thus, it won't be possible to code them using C#. More info - http://forums.microsoft...