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 |
|
supernova122
Starting Member
4 Posts |
 Posted - 2011-02-15 : 02:10:34
|
| I have 100+ packages running in SQL2000 server and this packages are developed by someone else. Now I want to quickly retrieve information on which packages run on a certain database and a certain table. Just wonder if the packagedata field in sysdtspackages contain these information. But I realize this field is not readable. How can I view it? If it doesn't contain information I need, how can I retrieve these information quick instead of going to check manually one by one? Please adivse me. Thanks. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-02-15 : 03:22:15
|
Why is it not readable?CONVERT(NVARCHAR(MAX), Col1) should do it.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
supernova122
Starting Member
4 Posts |
Posted - 2011-02-15 : 20:42:18
|
| Do you mean "CONVERT(NVARCHAR(MAX), packagedata)" ? |
|
|
|
supernova122
Starting Member
4 Posts |
Posted - 2011-02-15 : 20:46:02
|
| select CONVERT(NVARCHAR(MAX), packagedata) from sysdtspackagesAm I right? |
|
|
|
|
|
|
Urgent: dts packages