Solved

execute vbs from job step in dts

Posted on 2007-11-28
3
782 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

760 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now