Delete old DTS packages in SQL Server 2008
Learn how to delete DTS packges using TSQL
SQL Blogs
SQL and SQL Server database topics. Includes design, issue resolution and tips.
Using ActiveX to set query dynamically in SQL Server
Learn how to use ActiveX to dynamically change a query.
SQL Blogs
Common Table Expressions (CTE) in SQL Server 2005 and Up
Thanks to the team at TechRepublic.com and BOL, I have used CTEs to delete duplicates with ease in SQL Server
Using ActiveX to check the age of a file in SQL Server
Now, you can use ActiveX to check the age of a file before proceeding. The code assumes that you have already assigned the file location elsewhere in the DTS Package