Solved

execute vbs from job step in dts

Posted on 2007-11-28
3
786 Views
Last Modified: 2013-11-30
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.
0
Comment
Question by:casit
  • 2
3 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 500 total points
ID: 20369528
my thought is to check the connection setting....in the dts
0
 

Author Comment

by:casit
ID: 20369559
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
 

Author Comment

by:casit
ID: 20369649
Well the solution is to put wscript in front of the script in the command box.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question