07-19-2006 10:18 AM - edited 03-13-2019 11:55 PM
Hello - is there a way to programatically change the database Datasource name for database Read step in the script? The read step has a pre-populated dropdown list of datasource names which I assume come from the defined names in the system. I would like to be able to dynamically point to either TEST or PROD database (table names identical, DSN is different).
Thanks!
Mary
07-25-2006 10:12 AM
07-27-2006 09:54 AM
I looked at the link but found nothing that addressed the datasource names.
07-28-2006 01:44 AM
Why don't you try a SWITCH or IF step and have 2 DATABASE READ steps each one with a different DSN depending on the condition of the SWITCH or IF step.
07-28-2006 06:43 AM
Thank you for the suggestion. That would definitely work but I was hoping for something that might be a little "cleaner" since we have a couple of sripts that read/write to quite a few tables.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: