DSXchange

Hi, is it possible to pass different metadata definitions to the same generic job? RCP doesn't work for what we are trying to do. We want to use one job to load many tables. Want to pass everything the job needs by using job parameters.

You cannot pass the metadata that would be present within the column grid definitions in your input and output links, or transformer derivations, or items that are generally" non-parameterizable".

Things you can pass: Filter Stage Statements or portions thereof, modify stage logic, filenames, db connection information, SQL statements, schema filenames, sort/join/merge key columns, external filter/source/target names

Why won't RCP work for you? Be specific...maybe there's something that can be done.

Regards,

We don't know what you're trying to do, and therefore can not challenge your assertion about RCP.

I recently have had good success generating SQL dynamically based on reading metadata from the system tables and passing the SQL statements as job parameters. But this used RCP.

Even if you use the Schema File property with Sequential File stage, RCP must be enabled.