Skip to content
Rudy Rodarte . comRudy Rodarte . com

Rudy Rodarte . com

Follow Rudy as he programs, travels and designs.

  • Home
  • SQL Server
  • DTS & SSIS
  • ActiveX
  • Windows
  • About

Browsing Tag

ActiveX

SQL BlogsJanuary 11, 2018by Rudy1 min2,873

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 or reuse a file name. … Continue reading Overwrite files in a DTS using ActiveX

SQL BlogsJanuary 12, 2018by Rudy1 min1,734

Using ActiveX to set query dynamically in SQL Server

Learn how to use ActiveX to dynamically change a query. Continue reading Using ActiveX to set query dynamically in SQL Server

SQL BlogsJanuary 12, 2018by Rudy1 min1,510

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 Continue reading Using ActiveX to check the age of a file in SQL Server

SQL BlogsJanuary 11, 2018by Rudy1 min1,650

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 will be filename which contains … Continue reading Using ActiveX to Dynamically set a Variable in an SQL Server DTS Package

SQL BlogsJanuary 11, 2018by Rudy1 min2,364

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 a datetime or smalldatetime, SQL … Continue reading Change a Date Format Using ActiveX and SQL DTS Transformations

Powered by Passion Blogger WordPress Theme by appscreo.