Solved

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

Posted on 2011-09-11
4
460 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
ID: 36520031
>>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
ID: 36520258



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
ID: 36520277
>>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
ID: 36522446
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to Install SSIS without the SQL Server CD 3 45
Excel conversion issue with Sql server 14 47
Benefits of SMB Fileshare 3 63
Query Peformance + mulitple query plans 9 48
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
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.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

910 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

16 Experts available now in Live!

Get 1:1 Help Now