Overwrite files in a DTS using ActiveX
Several of my DTS jobs require processing a file and then archiving the file. As we all know, you can […]
ActiveX
Using ActiveX to set query dynamically in SQL Server
Learn how to use ActiveX to dynamically change a query.
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
Using ActiveX to Dynamically set a Variable in an SQL Server DTS Package
From time to time, you will need to dynamically set a variable in the middle of your DTS packages. The