ezkhan
asked on
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.
ASKER
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.
>>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".
Right, that is what I meant by "using SQL Server Agent".
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No. Normally dtexec is run from the command line using SQL Server Agent or some other scheduling app.