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
Read More...
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
Read More...
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
Read More...
