How to use different parameter sets at run time
Posted: Thu Sep 20, 2012 10:50 pm
Hello all,
I have a requirement like to get the query from one ref table from one database and the same should be passed to ODBC stage in a job and there after it fetches the data from database and loads into a dataset
My problem is i have different parameter sets defined for all sources
(Note : I can't use value file of parameter sets), it contains DSN,username and password, so accordingly my sources and dsn,username passd will change anyways i have a column defined the ref table which says which DB.
So how to generalize the job such that it takes the required dsn and loads the data into a dataset
I have a requirement like to get the query from one ref table from one database and the same should be passed to ODBC stage in a job and there after it fetches the data from database and loads into a dataset
My problem is i have different parameter sets defined for all sources
(Note : I can't use value file of parameter sets), it contains DSN,username and password, so accordingly my sources and dsn,username passd will change anyways i have a column defined the ref table which says which DB.
So how to generalize the job such that it takes the required dsn and loads the data into a dataset