Obtain a list of DTS packages

#1

Hi there,

I'm been trying to to find how to list all available DTS packages on SQL
Server, but still got no result. Can anyone please guide me. I'm having hard
time try to understand the Class Library.

Thanks in advanced.

Yanto

#2

Check out EnumPackageInfos in the BOL.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

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

Hi there,

I'm been trying to to find how to list all available DTS packages on SQL
Server, but still got no result. Can anyone please guide me. I'm having hard
time try to understand the Class Library.

Thanks in advanced.

Yanto

#3

Hello Yanto,

One way of doing it is this

http://www.sqldts.com/default.aspx?250

another way of course is to query msdb.dbo.sysdtspackages.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

Hi there,

I'm been trying to to find how to list all available DTS packages on
SQL Server, but still got no result. Can anyone please guide me. I'm
having hard time try to understand the Class Library.

Thanks in advanced.

Yanto

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

Obtain a list of DTS packages

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

Obtain a list of DTS packages - 02-13-2006 , 04:50 AM

Re: Obtain a list of DTS packages - 02-13-2006 , 06:05 AM

Re: Obtain a list of DTS packages - 02-13-2006 , 04:03 PM