Please tell me this is possible..
I need to create a DTS package - that will be run through a stored procedure. Which is somewhat simple enough.. My problem is the i need to select a certain record set that the user passes to the stored procedure.. For example - select * from table where state = 'NY' (NY would be passed in) - can i do this?
If this is possible - can someone point me in the right direction.
Thanks in advance..
I need to create a DTS package - that will be run through a stored procedure. Which is somewhat simple enough.. My problem is the i need to select a certain record set that the user passes to the stored procedure.. For example - select * from table where state = 'NY' (NY would be passed in) - can i do this?
If this is possible - can someone point me in the right direction.
Thanks in advance..