I am using timestamp as new folder name. Seems like if the folder is not exist, the file won't save at new path. Can the community advise how to create folder with ActiveX script? Thanks.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
You can use this code in DTS Activex Script
Set fso = CreateObject("Scripting.FileSystemObject") fso.CreateFolder ("C:\xxxx")
xxx = you can set the time and date
No one has followed this question yet.
DTS to SSIS migration throwing Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.".
Does Importing A Text File Using The DTS Wizard Requires Truncate Table?
Error while importing data from Excel to SQL server 2000 table
SQL Server 2000 - DTS - Dynamic SQL Server Connection
Export Table Data Using a Query