parametrised query in DTS in SQL 2000
-
I have been searching for threads in various forums best part of 7 months. I have finally plucked up the courage to write my own thread!
Can anyone tell me if there is a way around writing a DTS which runs a parametrised stored procedure? I have been advised by some one that i may need to wrap the SP within a UDF. Im no good with UDF's, any bright sparks out there able to point me in the right direction?? If youre in London I'll get you a pint!!!
Many thanks in advance!
-
Where did you want to run the stored procedure, in an ExecuteSQL task, or a Datapump task?
Either way, it's basically the same, EXEC stored_proc_name @param1=?, @param2=?, etc...
Then click the parameters button and assign appropriate global variables to the parameters collection.
--------------------
Colt 45 - the original point and click interface
-
what do you mean by assign appropriate global parameters collection?
I dont care where the SP is run, the SP inserts data into an existing table.
Thanks for your reply.!
-
Ok, so far we know,
a) you have a stored procedure that takes some parameters and inserts the data into a table
b) DTS is somehow involved as you're asking about "parametrised query in DTS in SQL 2000"
How about you fill in the gaps of what you are trying to achieve?
Where do the parameters for the stored procedure come from? How are you executing the stored procedure now? Where is data coming from and going to?
--------------------
Colt 45 - the original point and click interface
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply