rojas_alfredo
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
http://msdn.microsoft.com/en-us/library/ms167456(SQL.90).aspx