Patrick Index Passing Variables to and from an SSIS task In which Patrick Index casts a jaundiced eye on SSIS, and decides that, for all its faults, it has a number of uses as an... 20 August 2008 7 min read
David Leibowitz SSIS Package Componentization In this article, David Leibowitz describes methods for scalable SQL Server 2005 Integration Services package creation. If you're no stranger to OOP, then the methods... 29 April 2008 21 min read
Cristian Lefter Logon Triggers Login Triggers were quietly introduced in SP2 to tighten up the security features of SQL Server to comply with the latest industry standards for security.... 10 October 2007 28 min read