sql server reporting services: I am using a shared data source to access a Teradata machine but the password
I need to use is generated elsewhere in a component and changed regularly.
Is there a way I can get the shared data source to grab the current password

Interesting. Every now and then I come across a question that leaves me
baffled for a while. The guy who implemented this must have been really
influenced by trustworthy computing :-) I am just curious how will the data
source be synchronized with the new password.

Well, you can't change the connection string during runtime which limits (at
least as far as I can tell) your choices to:

1. If that component raises an event or if you have other means to know when
the password is going to be changed you can write a simple app to update the
shared data source definition programmatically.

2. Wrap this data source in a custom data extension.

--
Hope this helps.

-----------------------------------------------------
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
-----------------------------------------------------

[quoted text, click to view]