Rudy Rodarte . com

Posts Tagged "ActiveX"

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

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 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.