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 |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2001-12-10 : 16:50:03
|
| Hey all,This site has gone nuts since I was last here.I have a quandry. I wrote a DTS process that pulls data from Sql Server into Access so the users can download the data and play with it. yee haa.Well, I decided to change the password for the database account one stormy night, and I thought I could simply change my connection properties in the DTS designer, but it doesn't seem to want to stick. Can you alter the connection properties after you have created the package?Sql Server 7.0 running on NT 4. sp6or7 (whatever it is now).Thanks for any help, I am starting to bow my head to a rewrite._________________________Death is one day closer |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2001-12-10 : 16:58:25
|
| Howdy,In SQL2000, the connection properties can be edited without problems. I don't have an SQL7 available right now, so I can't test, but have you tried the disconnected edit option? You should be able to change all connection properties from in there. |
 |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2001-12-10 : 17:22:51
|
| HmmI don't know what the problem is. I simply ended up making a user with no password that has data reader rights to the database and that works. (this is a minimal security risk)DTS really acts quite strange rather frequently when I run it, and lots of errors. I assume that is the way it is in 7. 2k hasn't seemed to give me problems yet.*************************************I rebuilt the DTS process and the account with the password is usable. I don't understand how I can't edit a DTS process connection, but if it works in 2k, I won't get too excited. THis should be one of the last boxes with 7 i have to use.***************************************_________________________Death is one day closerEdited by - vivaldi on 12/11/2001 10:15:32 |
|
|
|
|
|
|
|
|
DTS Connection Properties