Existence of Package.

From: Sreenath (Sreenath_at_discussions.microsoft.com)
Date: 06/22/04

Next message: Jim Israel: "DTS Execution multiple servers dtsrun"
Previous message: John Peterson: "Re: DTS bug (?): Data Driven Query Task incorrectly replaces empty strings with NULL."
Next in thread: Allan Mitchell: "Re: Existence of Package."
Reply: Allan Mitchell: "Re: Existence of Package."
Messages sorted by: [ date ] [ thread ]

Date: Tue, 22 Jun 2004 11:35:02 -0700

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

Next message: Jim Israel: "DTS Execution multiple servers dtsrun"
Previous message: John Peterson: "Re: DTS bug (?): Data Driven Query Task incorrectly replaces empty strings with NULL."
Next in thread: Allan Mitchell: "Re: Existence of Package."
Reply: Allan Mitchell: "Re: Existence of Package."
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Problem Executing DTS Task from VB
... declaring a Package using the WITHEVENTS keyword is the issue... ... >>> LoadFromSQLServer method, but the Execute method ... > Darren Green (SQL Server MVP) ...
(microsoft.public.sqlserver.dts)
Re: Existence of Package.
... But I am looking even simpler methods, like Select Countfrom SysDtsPackages but this needs a permission on msdb. ... I have many packages and I want to check whether the package exists or not before trying to load the Package. ... > Allan Mitchell MCSE,MCDBA, ... > calling the LoadFromSqlServer method. ...
(microsoft.public.sqlserver.dts)
Re: Existence of Package.
... Enumerating DTS Packages using VB.Net ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I would like to call a Package B from Package A using LoadFromSqlServer ... calling the LoadFromSqlServer method. ...
(microsoft.public.sqlserver.dts)
Remote Access Configuration Errors
... Calling CRRASCommit::ValidatePropertyBag ... Reading VPN Server Name returned OK ... Running IExpress to build the package returned OK ... Modifying client setup config.dat for provisioning returned OK ...
(microsoft.public.windows.server.sbs)
Re: Saving SSIS Packages
... I tried using the import wizard, importing a file based package and migrating ... Is DTC required for importing into msdb? ... When using the import wizard in SQL Server Management Studio, ... Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, ...
(microsoft.public.sqlserver.dts)