Re: How do I call the another DTS Package's Task Lookup in a DTS P

#1

Do we have Global Lookups like Global Variables ?

regards
Krishna

"Allan Mitchell" wrote:

Quote:

Unfortunately I know of no way to do this.

"Krishna" <Krishna (AT) discussions (DOT) microsoft.com> wrote in message
news:Krishna (AT) discussions (DOT) microsoft.com:

I have one DTS Package say Package1 where i have most of the Lookups in one
Transform Data Task. I would like to call these Package1->Transform Data Task
->Lookups in another dts packages say Package2 in Activx Script instead of
writing lookups again.
Any help appreciatable.

#2

No, again unfortunately.

I have seen mention before where you can call certain methods in Script
tasks and use them like Global Functions but I do not have the location of
this article handy. The author may have been Trey Johnson

"Krishna" wrote:

Quote:

Do we have Global Lookups like Global Variables ?

regards
Krishna

"Allan Mitchell" wrote:

Unfortunately I know of no way to do this.

"Krishna" <Krishna (AT) discussions (DOT) microsoft.com> wrote in message
news:Krishna (AT) discussions (DOT) microsoft.com:

I have one DTS Package say Package1 where i have most of the Lookups in one
Transform Data Task. I would like to call these Package1->Transform Data Task
->Lookups in another dts packages say Package2 in Activx Script instead of
writing lookups again.
Any help appreciatable.

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

Re: How do I call the another DTS Package's Task Lookup in a DTS P

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

Re: How do I call the another DTS Package's Task Lookup in a DTS P - 06-01-2005 , 12:44 AM

Re: How do I call the another DTS Package's Task Lookup in a DTS P - 06-01-2005 , 04:33 AM