I was recently asked if it is possible to display the results of a query / stored procedure in an SSIS Message box. The answer is Yes, with a bit of C#.
Several of my DTS jobs require processing a file and then archiving the file. As we all know, you can use ActiveX to Copy or Move a file. Problem is, sometimes we need to reprocess or reuse a file name. … Continue reading Overwrite files in a DTS using ActiveX
Learn how to delete DTS packges using TSQL Continue reading Delete old DTS packages in SQL Server 2008
Learn how to use ActiveX to dynamically change a query. Continue reading Using ActiveX to set query dynamically 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 Continue reading Using ActiveX to check the age of a file in SQL Server
From time to time, you will need to dynamically set a variable in the middle of your DTS packages. The following code shows you how easy it is to build a variable dynamically. The variable will be filename which contains … Continue reading Using ActiveX to Dynamically set a Variable in an SQL Server DTS Package
Let’s say you are importing data from a flat file to SQL Server via DTS. Now, let’s say the date format in the source file is similar to this: YYYYMMDD. If your destination column is a datetime or smalldatetime, SQL … Continue reading Change a Date Format Using ActiveX and SQL DTS Transformations