<div>
Sorry I wasn't clear enough in my first post I jsut read it over :( &nbsp;It executes the dts package just fine. &nbsp;but the step after the dts is the cmdexec and that is where its failing. &nbsp;All I want to do in the cmdexec is execute a vbs script thats on the dtabase server.
</div>


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.

<div>
Well the solution is to put wscript in front of the script in the command box.
</div>


Well the solution is to put wscript in front of the script in the command box.

<div>
<div class="content wysiwyg-content">
I have a job that executes a dts package and then depending on whether it success or fails it goes to the next step. &nbsp;The next step is a CmdExec<br />
I get the following in log<br />
reason %1 is not a valid Win32 application<br />
<br />
I currently have in their C:\scripts\dts_good.vbs<br />
Which I can run fine locally from the server. &nbsp;However I am running this step from another server on the network since enterprise manager is busted on this sql server.
</div>
</div>


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.

execute vbs from job step in dts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.