Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-27 : 09:09:03
|
| Dan writes "I am trying to rename some extract files as 'filename'.ddmmyy to prevent my DTS package from overwriting them. I am using the scripting.filesystemobject, however I get an error. The error reads as follows "ActiveX component can't create object 'Create Object'"dim fsoset fso = CreateObject("Scripting.FileSystemObject")Is filesystemobject part of MDAC ?" |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-06-27 : 13:04:37
|
| I believe the Scripting library is VBScript. You can d/l the latest from the MSDN site.Jonathan Boott, MCDBA |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-27 : 13:14:19
|
It also depends if you are doing this on the server or on your PC via EM. On the server open a cmd prompt and type cscript and hit enter, ifWSH is installed you should get backD:\>cscriptMicrosoft (R) Windows Script Host Version 5.6Copyright (C) Microsoft Corporation 1996-2000. All rights reserved.Usage: CScript scriptname.extension [option...] [arguments...] If no then goto [url]http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/msdn-files/027/001/733/msdncompositedoc.xml[/url]HTHJasper Smith |
|
|
|
|
|
|
DTS & filesystemObject