Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help

Status
Not open for further replies.

Bell1991

Programmer
Aug 20, 2003
386
US
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..
 
You can pass parameters to the DTS ...

thread183-588474

[flowerface]

I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top