March 22, 2006 at 7:09 pm
Would anyone know if it is possible to run a stored procedure, with OUTPUT parameter, from a lookup query in a Data Drive Query task in DTS? Actually I've figured out how to execute a stored procedure. The problem I'm having is getting the output parameter value and making use of it.
Maybe I'm way off base on this one... I'd like to execute the lookup query from the Data Drive Query Task's ActiveX Script Transformation. The lookup query will then execute the stored procedure and return the OUTPUT parameter's value to the ActiveX Script Transformation.
Any ideas, suggestions, or comments will be appriciated. Thanks.
David
March 22, 2006 at 9:24 pm
March 23, 2006 at 11:12 am
If you can use some sort of crazy join on your ddq to get the same results... it would execute much faster...
If that is not an option, setup caching on your lookups. make sure your stored proc has "SET NOCOUNT ON" atop the script will usually get your output params working correctly. Also make absolute certain that you are not creating any Exclusive locks within the SP or you will deadlock your table faster than you can say "who stole me Lucky Charms".
-Mike Gercevich
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply