SolvedPrivate

How do you call a package from a stored procedure?

Posted on 2014-11-13
6
36 Views
Last Modified: 2016-02-13
How do you call a package from a stored procedure?
0
Comment
Question by:LeVette Alexander
  • 3
  • 2
6 Comments
 
LVL 5

Expert Comment

by:scgstuff
Comment Utility
I call from ASP.NET code behind, but you should be able to do the same using this format....

Create a SQL Server Agent Job

Create procedure to execute:
EXEC MSDB.DBO.SP_START_JOB N'SQLJobName' 

Open in new window

0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
Comment Utility
0
 

Author Comment

by:LeVette Alexander
Comment Utility
I'm using sql server 2008 r2.  I'm calling the package from a share and passing three variables to the package.
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Author Comment

by:LeVette Alexander
Comment Utility
error is dtexec is not recognized as an internal or external command
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
Comment Utility
you need to provide the exact path. do a search on windows on the server and find the path
0
 

Author Comment

by:LeVette Alexander
Comment Utility
Aneesh, your first solution assisted me.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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.
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
Via a live example, show how to shrink a transaction log file down to a reasonable size.

772 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

9 Experts available now in Live!

Get 1:1 Help Now