Hi,

I m running the SSIS package by scheduling it in a job.
When the job is started, SSIS package is also started.
But now we can able to delete that SSIS package when it is running

Is there anyway to stop the deletion of package while it is running
and
How to know that SSIS package is running through T-SQL


Babs

Hello Contact_babs,

How are you storing the package?
You can stop people deleting it by denying them the ability to do that in
the staore location so file perms etc.

The thing is you can delete packages in DTS as well whilst they are loaded
into the designer. They are loaded into the calling/editing program and
then they cease to be the thing on disk. Think of it as a copy.

I do not think you can query the running package through TSQL and unless
you store them in MSDb and/or the package store then you will not be able
to know when they are running period.

SSMS has the running package section in the SSIS service and you can query
for them in a programming language of your choice using GetRunningPackages

Have a look here in BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9mref/html/M_Microsoft_SqlServer_Dts_Runtime_Application_GetR unningPackages_1_16219e3a.htm


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