<div>
&gt;&gt;Is there a way to run ssis package from stored procedure using dtexec utility which avoids the use of xp_cmdshell?&lt;&lt;<br />
No. &nbsp;Normally dtexec is run from the command line using SQL Server Agent or some other scheduling app.<br />

</div>


>>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.


<div>
<br />
<br />
<br />
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.
</div>





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.

<div>
&gt;&gt;But, I have managed to solve the problem by myself and ran it using sp_start_job&lt;&lt;<br />
Right, that is what I meant by &quot;using SQL Server Agent&quot;.
</div>


>>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".

<div>
<div class="content wysiwyg-content">
<br />
<br />
Hi,<br />
<br />
I have a situation wher I need to pass parameters to SSIS variables using stored procedure.<br />
<br />
I am reluctant to us xp_cmdshell to run the package from stored procedure.<br />
<br />
Is there a way to run ssis package from stored procedure using dtexec utility which avoids the use of xp_cmdshell?<br />
<br />
Your comments and suggestions are highly appreciated.<br />
<br />
Thanks.
</div>
</div>




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.

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

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.