May 19, 2005 at 10:27 am
Hi guys!
Here's the situation:
I need to remove the password from a DTS.
I know the current password, I just need to remove it, so that when the DTS runs it doesn't prompt me for the password.
How can I do this?
[]
Bruno
May 19, 2005 at 11:21 am
There's probabely another way, but it looks like you have to do a save has under another name (no password this time). Delete the old one and rename the new one.
May 19, 2005 at 7:06 pm
That's the only way I've found to do it.
Greg
Greg
May 20, 2005 at 3:48 am
THX!
That's what I did and it worked, now I've got another problem:
One of the tasks on my DTS is execute a stored procedure, and when I execute it an error message pops up saying the DTS can't find the sp, although I can see it under the stored procedures of the DB.
Any thoughts on this matter?
THX
--
Bruno
May 20, 2005 at 4:57 am
Arer you specifying the owner of the sp when you executing it? If the owner is something other then dbo you need to include it.
Other thought is connection used to the correct db?
May 20, 2005 at 8:27 am
The problem was exactly that, the owner wasn't specified.
I fixed that, but now I'm having yet another problem, which is described on a new topic: 'DTS exec error!'
If you could help me with this I'd appreciated!
Thank you very much!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply