Problem running a DTSX package from Stored Procedure

Posted on 2008-11-04
Last Modified: 2013-11-30
I can run a DTSX package from the command line and from a query in the Server Management Studio.
The problem is that i need this line to run in a Stored Procedure. When i run the Stored Procedure it hangs just when executing the DTSX Package.

Any ideas?
Question by:rojas_alfredo
    LVL 11

    Expert Comment

    Have you considered adding logging to your SSIS  package to see what is going on?
    LVL 17

    Accepted Solution

    Save the dtsx package into a SQL Server Agent Job. Then use the sp_start_job stored procedure from your stored procedure to execute. It will not wait for a result.
    As to why the stored procedure is hanging, please send code if you want to debug. Thanks.

    Author Closing Comment

    Thank's for the solution, i saved the package as a job and i just wrote some code to check the status of the job and voila.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    737 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

    17 Experts available now in Live!

    Get 1:1 Help Now