How to pass database name as parameter for connectivity
Posted: Wed Jan 05, 2011 5:51 pm
Is there a way to pass database name as a parameter in DataStage ?
Basically, there can be many (hundreds) of databases on a single server, and I'm trying to find a way to dynamically switch the data source / target at run time.
I don't think this can be accomplished within ODBC Connector stage because DSN is bound to a single database (and I'm trying to avoid creating DSN for every database on the server).
Any way to accomplish this with SQL Server Enterprise or MS OleDB stage ?
Thank you!
Basically, there can be many (hundreds) of databases on a single server, and I'm trying to find a way to dynamically switch the data source / target at run time.
I don't think this can be accomplished within ODBC Connector stage because DSN is bound to a single database (and I'm trying to avoid creating DSN for every database on the server).
Any way to accomplish this with SQL Server Enterprise or MS OleDB stage ?
Thank you!