Prev: view_metadata treated as materialized
Next: How to copy a DTS package?
From: Prem Mehrotra on 4 Feb 2010 20:02
1. I am still on SQL Server 2000. Is there a way some sql query e.g. on
tables in msdb database), so I can find when was last time various packages
were modified. I only see create date for pacakages in Entterprise Manager
or in msdb sysdtspacakges

I know in Enterprise Manager one can go to each DTS package one by one look
at its various versions and perhaps try to figure this out, but I am looking
for a faster way.

2. Is there some sql query to find sql used inside transformation of various
DTS pacakges. Going in Designer in EM and clicking on properties on arrows
connecting two connections is tedious when there are so many pacakages.

THANKS A LOT.

From: Uri Dimant on 7 Feb 2010 04:40
Hi
In SQL Server 2000 if someone modified the package next time you open it
you'll see the versin tree of the package, do you see that?


"Prem Mehrotra" <PremMehrotra(a)discussions.microsoft.com> wrote in message
news:3D7F87A6-A737-4279-9796-A63F2EEEA5FD(a)microsoft.com...
> 1. I am still on SQL Server 2000. Is there a way some sql query e.g. on
> tables in msdb database), so I can find when was last time various
> packages
> were modified. I only see create date for pacakages in Entterprise
> Manager
> or in msdb sysdtspacakges
>
> I know in Enterprise Manager one can go to each DTS package one by one
> look
> at its various versions and perhaps try to figure this out, but I am
> looking
> for a faster way.
>
> 2. Is there some sql query to find sql used inside transformation of
> various
> DTS pacakges. Going in Designer in EM and clicking on properties on arrows
> connecting two connections is tedious when there are so many pacakages.
>
> THANKS A LOT.
>


 | 
Pages: 1
Prev: view_metadata treated as materialized
Next: How to copy a DTS package?