DTS Dependent Objects 
Author Message
 DTS Dependent Objects
I was asked how do you determine what stored procedures our several dts are
dependent on.

So that we could determine which stored procedures we no longer need, since
we cannot find there use anywhere else.

My reply was we could store them as files and search the files.  Is there a
better approach?

Thank You,
Carol



Tue, 13 Sep 2005 00:07:21 GMT
 DTS Dependent Objects

Yes, you cound save them as vb files and search them, but you could, even
should
use a really nice tool that will document your DTS package completely.
The completed documentation can be given to your client as well.

http://www.mosaicinteractive.com/DTSXML80/default.asp

Regards
Habib


| I was asked how do you determine what stored procedures our several dts
are
| dependent on.
|
| So that we could determine which stored procedures we no longer need,
since
| we cannot find there use anywhere else.
|
| My reply was we could store them as files and search the files.  Is there
a
| better approach?
|
| Thank You,
| Carol
|
|



Tue, 13 Sep 2005 00:38:15 GMT
 DTS Dependent Objects
You will have to resort to something like that (saving to files and
searching), as the dependency information is not maintained anywhere.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm


I was asked how do you determine what stored procedures our several dts are
dependent on.

So that we could determine which stored procedures we no longer need, since
we cannot find there use anywhere else.

My reply was we could store them as files and search the files.  Is there a
better approach?

Thank You,
Carol



Tue, 13 Sep 2005 00:42:30 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Dependent objects script is empty although many dependent objects exist

2. SQL Server Copy Object Task: include dependent objects

3. DTS Object Copy vs. DTS Object Transfer

4. Access right inheritance (for dependent objects)

5. Update from object types with type or table dependents

6. SQL 7.0 Generate SQL Scripts with Dependent Objects

7. Update from object types with type or table dependents

8. SP_DEPENDS not showing all dependent objects

9. Dependent Objects in scripts

10. Finding dependent objects in different DB

11. How to disable check dependent object ?

12. How To List the dependent objects of defaults


 
Powered by phpBB® Forum Software