August 13, 2002 at 12:45 am
can anyone help? i've got a major problem here. i've used DTS to ouput a SQL table to a text file called myText.txt. Now i want the text file to be renamed so it includes the date, e.g. yyyymmdd.txt. i've managed this via an "Active X" script in a stand-alone DTS package. When i run this manually everything works fine. When i schedule the DTS package to run as a job i get an error complaining about "CreateObject"....(used in my code to create the Scripting.FileSystemObject). Anyone help???
August 13, 2002 at 1:51 am
by the way i'm using SQLserver 7.
August 13, 2002 at 5:03 am
Start my making sure you have scrun.dll registered on the machine where the package is executing.
Andy
August 13, 2002 at 10:14 pm
yup, that's the ticket. Install Internet Explorer on the box running the job and you should be good to go.
When you execute the package from your worksstation, it's using the scrrun.dll on your workstation to do the scripting work.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply