Passing Substring of Parameter into Table Name
Posted: Wed Apr 20, 2005 5:31 am
Hi,
Jobs are writing the Data into a Table /Extracting Data from table
Actual requirement i want to pass table name as dynamic.
Table Name is substring of one of the job parametre
Example :
Parameter Values have like ABC_XYZ
How can i pass 'ABC' as Table Name?
Can anybody share the ideas ?
Thanks in Advance
Jobs are writing the Data into a Table /Extracting Data from table
Actual requirement i want to pass table name as dynamic.
Table Name is substring of one of the job parametre
Example :
Parameter Values have like ABC_XYZ
How can i pass 'ABC' as Table Name?
Can anybody share the ideas ?
Thanks in Advance