all groups > sql server dts > march 2007 >
You're in the

sql server dts

group:

DTS LookUps



DTS LookUps Gramps
3/14/2007 12:00:00 AM
sql server dts: Hi,


Can a Look-up be made 'global' to an entire package?

I have a Data Driven Query (DDQ), built using DTS designer and it has
Lookup1. In the same package, I have another DDQ and it also needs the
functionality of this look-up.

How can I make this look-up (or it's functionality) global to the package so
that each DDQ can use it and I don't repeat the look-up in each DDQ?


Thanks

Re: DTS LookUps Allan Mitchell
3/14/2007 6:46:03 AM
No. Lookups will be specific to the DDQ you are using.

--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com



[quoted text, click to view]
AddThis Social Bookmark Button