Posts Tagged "DTS"
Check out all of the posts tagged with "DTS".
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 ...
Delete old DTS packages in SQL Server 2008
Do you have tons and tons of versions of DTS packages in SQL Server 2008/2005. Every little revision saves a new version on the server. You could end up with hundreds of revisions for just ...
Using ActiveX to set query dynamically in SQL Server
Most of the time, the transformations between Oracle and SQL Server databases work without incident. But one project I was on experienced a several issues. The task required setting global variables in SQL DTS, then ...
Using ActiveX to check the age of a file in SQL Server
You may run into a case where working with old data can cause issues downstream. Now, you can use ActiveX to check the age of a file before proceeding. The code assumes that you have ...
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 ...
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 ...
Adding Foreign Keys after a table is created in SQL Server
Well, you knew exactly what you needed when you created a table. Only now when you created a child table, the child table does not update with the information from your main table. Or worse ...