dataset append giving error

prams · Post by **prams** » Thu Mar 12, 2009 12:52 am

Hi

In one of my job dataset i am using for rejected rows.but i need to append it every time.in dataset i selected the option "append" but it is giving the below error

Data_Set_199: Operator initialization: The data "/ETL_FILES/GlobalSales/etl/datasets/GSRExt_TRANSSUMM_INT.ds" is used as output multiple times
Operator initialization: The data "/ETL_FILES/GlobalSales/etl/datasets/GSRExt_TRANSSUMM_INT.ds" may not have more than one file/ds override.

can any one please help me in this regard.

Thanks
Prams

ray.wurlod · Post by **ray.wurlod** » Thu Mar 12, 2009 2:59 am

Only one append is permitted in any one job, apparently.

mahadev.v · Post by **mahadev.v** » Thu Mar 12, 2009 2:59 am

Search on "is used as output multiple times". Are you using the same DataSet twice in the same job?

prams · Post by **prams** » Thu Mar 12, 2009 4:07 am

Thanks for the quick turn around

i am using only once in the job, but i need to append the data when i ran the job next time.

Thanks
Prams