Import Files with Date-stamped Filenames or Paths
March 10, 2003MAK [Muthusamy Anantha Kumar]
DTS packages are fantastic features available in SQL Server 7.0 and SQL server 2000. One outstanding feature in the DTS package is the ability to run ActiveX scripts. ActiveX gives us an added advantage in handling many situations; we will discuss how to handle three of these situations.
Create Connection to Source files and database.
Give the source file names of SourceFile1 and SourceFile2 to any existing files, for example c:\autoexec.bat. We are going to control the Path of the connections through ActiveX Controls.
Create Transformation between Sourcefiles and Database connections.
Now create two ActiveX scripts, one for each sourcefile.