[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 816
  • 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

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

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