Page 1 of 1

dataset append giving error

Posted: Thu Mar 12, 2009 12:52 am
by prams
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

Posted: Thu Mar 12, 2009 2:59 am
by ray.wurlod
Only one append is permitted in any one job, apparently.

Posted: Thu Mar 12, 2009 2:59 am
by mahadev.v
Search on "is used as output multiple times". Are you using the same DataSet twice in the same job?

Posted: Thu Mar 12, 2009 4:07 am
by prams
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