Solved

Runnin an Integrated Service Package via vbscript

Posted on 2006-11-21
2
892 Views
Last Modified: 2012-06-27

Hey all,

I have an SSIS package that I wrote and deployed, lets call it PACKAGE.dtsx

I need to run the package via vbscript and cannot find any documentation on it.

Anyone have any idea?

Thanks  :)
0
Comment
Question by:wbcintsol
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Accepted Solution

by:
drydenhogg earned 500 total points
ID: 17994043
There is an application DTSEXEC.EXE which can run SSIS packages, an example would be something like

dtsexec /Server yourServer /D c:\yourpath\package.dtsx

There are a lot of different command line options for it, a comprehensive list is at http://msdn2.microsoft.com/en-gb/library/ms162810.aspx

hth.
0
 

Author Comment

by:wbcintsol
ID: 18073976
Thanks!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
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.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

739 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