execute vbs from job step in dts

I have a job that executes a dts package and then depending on whether it success or fails it goes to the next step.  The next step is a CmdExec
I get the following in log
reason %1 is not a valid Win32 application

I currently have in their C:\scripts\dts_good.vbs
Which I can run fine locally from the server.  However I am running this step from another server on the network since enterprise manager is busted on this sql server.
casitAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
James MurrellConnect With a Mentor Product SpecialistCommented:
my thought is to check the connection setting....in the dts
0
 
casitAuthor Commented:
Sorry I wasn't clear enough in my first post I jsut read it over :(  It executes the dts package just fine.  but the step after the dts is the cmdexec and that is where its failing.  All I want to do in the cmdexec is execute a vbs script thats on the dtabase server.
0
 
casitAuthor Commented:
Well the solution is to put wscript in front of the script in the command box.
0
All Courses

From novice to tech pro — start learning today.