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.
How to execute a DTS task programmitcally using C#.
Restore a DTS exported BAS file to DTS package - SQL 2000
How can I get data from multiple text files into a SQL 2000 table?
Does Importing A Text File Using The DTS Wizard Requires Truncate Table?
DTS to SSIS migration throwing Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.".