• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 836
  • Last Modified:

Problem running a DTSX package from Stored Procedure

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?
0
rojas_alfredo
Asked:
rojas_alfredo
1 Solution
 
SwindleCommented:
Have you considered adding logging to your SSIS  package to see what is going on?

http://msdn.microsoft.com/en-us/library/ms167456(SQL.90).aspx
0
 
HoggZillaCommented:
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. http://msdn.microsoft.com/en-us/library/ms186757(SQL.90).aspx
As to why the stored procedure is hanging, please send code if you want to debug. Thanks.
0
 
rojas_alfredoAuthor Commented:
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.
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.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now