Re: Existence of Package.

#1

Yep.

have a look here for an idea of how you might do it.

Enumerating DTS Packages using VB.Net
(http://www.sqldts.com/default.aspx?250)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

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

Quote:

Hi,
I would like to call a Package B from Package A using LoadFromSqlServer
method. Is there any way to check whether the Package B exists before

calling the LoadFromSqlServer method. I don't want to poll the table in
MSDB.

Quote:

Thanks,
Sreenath

#2

That is one way I suppose

Public has Execute permissions on the stored procedure I gave you. Guest is
by default a member of MSDB and so therefore any server login has the
ability to execute that proc.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

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

Quote:

Thanks Allan,
But I am looking even simpler methods, like Select Count(*) from
SysDtsPackages but this needs a permission on msdb. Probably the user may

not get the access.

Quote:

I have many packages and I want to check whether the package exists or not
before trying to load the Package.
The procedure you mentioned will take more steps, which i dont' want to
do. Ofcourse, if there is no other option...Probably, I do.

Thanks,
Sreenath

"Allan Mitchell" wrote:

Yep.

have a look here for an idea of how you might do it.

Enumerating DTS Packages using VB.Net
(http://www.sqldts.com/default.aspx?250)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Sreenath" <Sreenath (AT) discussions (DOT) microsoft.com> wrote in message
news:481B5089-2456-462A-B1DE-9B01E9C6AACB (AT) microsoft (DOT) com...
Hi,
I would like to call a Package B from Package A using
LoadFromSqlServer
method. Is there any way to check whether the Package B exists before
calling the LoadFromSqlServer method. I don't want to poll the table in
MSDB.
Thanks,
Sreenath

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

Re: Existence of Package.

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

Re: Existence of Package. - 06-22-2004 , 03:53 PM

Re: Existence of Package. - 06-23-2004 , 02:42 AM