I have a <file>.vbs file that builds a .js file that I am using for a website. Can I use DTS to run the <file>.vbs file? If so. how?

Can you not call it through the ExecuteProcess task ?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"ejgreen" <ejgreen (AT) teppco (DOT) com> wrote

Referencing a <file>.vbs by using the Execute Process Task in SQL DTS generates one of the -214.......errors

The typical file formats for Execute Process Task are .exe , .dat, .bat, etc.

I guess it cannot run .vbs files

My .vbs file make a connection to an Oracle database then create a filesystemobject to place data in a .js file

I just want to run these vbs script files as part of my DTS package.

Any other thoughts????

Actually Allan, I got it to work by copying for .vbs file into a ActiveX script task. I just had to change my DataSource from Microsoft Oracle connection to the Oracle connection.....