Solved

pass paramters to ssis and run it from stored procedure without xp_cmdshell utility!!!!!

Posted on 2011-09-11
4
458 Views
Last Modified: 2012-05-12


Hi,

I have a situation wher I need to pass parameters to SSIS variables using stored procedure.

I am reluctant to us xp_cmdshell to run the package from stored procedure.

Is there a way to run ssis package from stored procedure using dtexec utility which avoids the use of xp_cmdshell?

Your comments and suggestions are highly appreciated.

Thanks.
0
Comment
Question by:ezkhan
  • 2
4 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
>>Is there a way to run ssis package from stored procedure using dtexec utility which avoids the use of xp_cmdshell?<<
No.  Normally dtexec is run from the command line using SQL Server Agent or some other scheduling app.
0
 

Author Comment

by:ezkhan
Comment Utility



Thanks for your answer; But, I have managed to solve the problem by myself and ran it using sp_start_job with a custimized logic in stored procedure to implement with parameter values.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
>>But, I have managed to solve the problem by myself and ran it using sp_start_job<<
Right, that is what I meant by "using SQL Server Agent".
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 500 total points
Comment Utility
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

762 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