Rudy Rodarte . com

Posts Tagged "DTS"

Check out all of the posts tagged with "DTS".

Stored Procedure Results in an SSIS Message Box

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#. RudyRudy Rodarte is […]

Mar, 08

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 use ActiveX to Copy or Move a file. Problem is, sometimes we need to reprocess […]

Feb, 12
Learn how to delete DTS packges using TSQL

Delete old DTS packages in SQL Server 2008

Learn how to delete DTS packges using TSQL

Feb, 11
Learn how to use ActiveX to dynamically change a query.

Using ActiveX to set query dynamically in SQL Server

Learn how to use ActiveX to dynamically change a query.

Jan, 22
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 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

Jan, 22

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 following code shows you how easy it is to build a variable dynamically. The variable […]

Jan, 22

Change a Date Format Using ActiveX and SQL DTS Transformations

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 […]

Jan, 21

Navigation

Please use the navigation to move within this section.