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



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.
ezkhanAsked:
Who is Participating?
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
0
 
Anthony PerkinsCommented:
>>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
 
ezkhanAuthor Commented:



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
 
Anthony PerkinsCommented:
>>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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.