March 22, 2006 at 6:55 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 6:59 pm
Did you read EXECUTE topic in BOL?
_____________
Code for TallyGenerator
March 22, 2006 at 7:11 pm
Thanks for the reply.
I hate to ask, but what is the BOL?
March 22, 2006 at 7:34 pm
Book On Line.
"Help" for MSSQL 2000.
You can open it by pressing F1.
_____________
Code for TallyGenerator
March 22, 2006 at 9:25 pm
Posted here.
There is no need to cross post. We usually check all boards
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=267793
March 22, 2006 at 9:56 pm
What is the source of the DDQ, the target of the DDQ and the connection used for the lookup ?
If they are all tables/views/sprocs on the same SQL instance, then a DDQ is not the appropriate method for moving the data.
Even if they are on disparate systems, you will usually be able to build a solution that is:
- faster by orders of magnitude
- easier to debug
- able to support version control
... by using a really simple DTS datapump to copy data from other systems into staging tables on the same SQL instance, then doing all the work in T-SQL.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply