|
Home > Archive > MS SQL Server DTS > September 2005 > find a query/table from available DTS packages
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
find a query/table from available DTS packages
|
|
|
| HI All,
I am updating a DTS package created by smeone else. There is a table used in
where condition. I need to find out how this table is populated. There are
650 DTs packages and searching all of them for finding this table is tedious
job. can neone suggest a better method?
thanks
| |
| Ilya Margolin 2005-09-22, 9:23 am |
| k_s,
Your best bet would be writing a VB program to loop through packages and
expose package components.
Ilya
"k_s" <ks@discussions.microsoft.com> wrote in message
news:9E5E6438-0C26-4C92-98E4- 521586AD614C@microso
ft.com...
> HI All,
> I am updating a DTS package created by smeone else. There is a table used
in
> where condition. I need to find out how this table is populated. There are
> 650 DTs packages and searching all of them for finding this table is
tedious
> job. can neone suggest a better method?
>
> thanks
| |
|
|
thanks for the reply Ilya ,
can I get the querries written in SQl tasks also?
I have not used DSO in VB before, so I think it'll be a learning process. I
don't have that much time to spend.
"Ilya Margolin" wrote:
> k_s,
>
> Your best bet would be writing a VB program to loop through packages and
> expose package components.
>
> Ilya
>
> "k_s" <ks@discussions.microsoft.com> wrote in message
> news:9E5E6438-0C26-4C92-98E4- 521586AD614C@microso
ft.com...
> in
> tedious
>
>
>
|
|
|
|
|