using DTS Lookup and stored procedures or UDFs

#1

I need to use a DTS Lookup, I would prefer to use a SPROC
or UDF as the source however it appears to only take a
paremterized query is there a workaround for this??????

#2

You can use a proc so long as it returns a rowset

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Jason" <jhorner (AT) flyfrontier (DOT) com> wrote

Quote:

I need to use a DTS Lookup, I would prefer to use a SPROC
or UDF as the source however it appears to only take a
paremterized query is there a workaround for this??????

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

using DTS Lookup and stored procedures or UDFs

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

using DTS Lookup and stored procedures or UDFs - 07-15-2003 , 12:15 PM

Re: using DTS Lookup and stored procedures or UDFs - 07-15-2003 , 01:16 PM