question

Stan avatar image
Stan asked

How to create a folder in SQL Server 2000 DTS ActiveX script

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.

sql-server-2000scriptdts
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Leo avatar image
Leo answered

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

Thanks.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.