Dependencies

#1

Do you know of any way to identify all the objects,
including child objects, that a DTS package uses?

#2

The only way I know of to do this would be walk the package using the object model. This could become very intrivate very quickly.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

"BL" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Do you know of any way to identify all the objects,
including child objects, that a DTS package uses?

#3

What do you mean by object model.

Quote:

-----Original Message-----
The only way I know of to do this would be walk the
package using the object model. This could become very

intrivate very quickly.

Quote:

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

"BL" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message news:108301c536cf$900739d0$a401280a (AT) phx (DOT) gbl...
Do you know of any way to identify all the objects,
including child objects, that a DTS package uses?

.

#4

DTS has an object model. It allows you to program against DTS

Have a look here in BOL

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\dtsprog.chm::/dtspapps_21rn.htm

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

<anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

What do you mean by object model.
-----Original Message-----
The only way I know of to do this would be walk the
package using the object model. This could become very
intrivate very quickly.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

"BL" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message news:108301c536cf$900739d0$a401280a (AT) phx (DOT) gbl...
Do you know of any way to identify all the objects,
including child objects, that a DTS package uses?

.

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

Dependencies

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

Dependencies - 04-01-2005 , 10:29 AM

Re: Dependencies - 04-03-2005 , 06:26 AM

Re: Dependencies - 04-04-2005 , 07:59 AM

Re: Dependencies - 04-04-2005 , 12:56 PM