Friday, March 9, 2012

DTS Package- Check its useability

I have a quick question, I am working on some new SQL Servers that
were being managed by other DBA's. I am going through a list of DTS
packages and there are some that I am not certain if they are being
used anymore. Is there a way in SQL Server to identify how often the
DTS packages are being executed so that I can tell if it is being
used?
Any help in this regard will be greatly appreciated.
ThanksIf logging is already enabled, right click the package and select Package
Logs.
If logging is not enabled you can enable it. Open the package, go to Package
in the menu, Properties, Logging tab and Logging section.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"shub" wrote:

> I have a quick question, I am working on some new SQL Servers that
> were being managed by other DBA's. I am going through a list of DTS
> packages and there are some that I am not certain if they are being
> used anymore. Is there a way in SQL Server to identify how often the
> DTS packages are being executed so that I can tell if it is being
> used?
> Any help in this regard will be greatly appreciated.
> Thanks
>

No comments:

Post a Comment