DTS package - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

DTS package

Author

Topic

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-08-08 : 23:52:24

Any ideas how could I find which DTS package is using certain database?

=============================
http://www.sqlserverstudy.com

nr
SQLTeam MVY

12543 Posts

Posted - 2007-08-09 : 04:03:06

Use the profiler to see when the database is accessed.
Rename the database and see what fails.
This will script the properties of packages then you can search the result
http://www.nigelrivett.net/DTS/ScriptDTSProperties.html

This saves packages to a storage file. You can change it to save to a vb script and search that
http://www.nigelrivett.net/DTS/SaveAllDTSPackagesToFiles.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources