Using SAS Data Integration Studio 4.9, I use the Data Validation transformation. I select all columns from source table on Mapping tab. On Duplicate Values tab I select a column and "action if duplicates:" i select "Move all but one row to error table". On the Error and Exception Tables tab, I select Create error table and choose all columns. I run the transformatino and it works, creating both a output table and an error table. I can put those in an extract transformation. However, when I try to save my job, it gives me an error message - error writing metadata. The I/O subsystem returned error message ' ERROR: Library I0000698 does not exist.' while attempting to dreate the event container in the Foundation repository. I can save the job but when I reopen the job it comes up with a message that it is removing the transformation. So do I need to define the library for the output table somewhere? Thanks.
... View more