Solved

Runnin an Integrated Service Package via vbscript

Posted on 2006-11-21
2
899 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

631 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