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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2007-04-25 : 17:15:49
|
| Hi I have a DTS package were i need to make a change to the code in the data transformation link from a server to my local server, the creater of the package is not me, but am now the owner of it, when i made a change to the DESCRIPTION of the package the owner id went for me to the creator id am getting a Hresult error that makes no sense, and am also in the sys admin role in the logins any idea's why can't edit the code, when i parse my change am getting the Hresult x00000 numberAlso when i changed the DTS description properties the owner id went from me to the creator id who was someone else ? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-25 : 17:39:21
|
| I did those kind of changes and worked ok. Tried save to another name? |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-04-25 : 17:46:42
|
| Try save the DTS package as another name ? i did do that and it saves as my own owner id |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-26 : 13:30:55
|
| Then try edit it to see if still get error. |
|
|
|
|
|
|
DTS permissions