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.
| Author |
Topic |
|
denisevaralda
Starting Member
2 Posts |
 Posted - 2008-04-01 : 07:13:10
|
| I have never used SQL server before and due to some circustances I have been asked to fix some reporting issues.I am using SQL Server version 2005.I wonder if it is possible to do a "search" in all DTS packegs to find which DTS packages uses a specific table.I have searched each DTS package but with no joy.regard,denise |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-01 : 07:17:04
|
| Seehttp://www.nigelrivett.net/DTS/ScriptDTSProperties.htmlYou can use that to script the properties of the dts packages and then do a search (or amend the code to just script what you want).You could also script as a vb module and search the text.==========================================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. |
 |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-04-01 : 08:21:05
|
quote:
Originally posted by denisevaralda
I have never used SQL server before and due to some circustances I have been asked to fix some reporting issues.I am using SQL Server version 2005.I wonder if it is possible to do a "search" in all DTS packegs to find which DTS packages uses a specific table.I have searched each DTS package but with no joy.regard,denise
Can you please tell how DTS is being used with SQL 2005?Prakash.PThe secret to creativity is knowing how to hide your sources! |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-01 : 08:22:55
|
| It's just a client app - it can connect to a sql server v2005 database.==========================================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. |
|
|
|
denisevaralda
Starting Member
2 Posts |
Posted - 2008-04-01 : 09:50:02
|
| Thanks nr, i will try it |
|
|
|
|
|
|
Search the DTS package