DSXchange

Hi
I imported a job from development enviornment to test enviorment using istool import and export command.

When I try to read the source (Oracle table), I get a message as

Generate SQL is a required link property for Link DSLink1

My sql is custom sql and works fine in development enviornment
I am using the same database as used in development enviornment but gives me above error in test enviornment.

Ketfos

You might want to try right-clicking on the stage and selecting 'Grid style' to verify all of the settings. Do this in both dev and test to compare.

The error message suggests that the user-defined SQL is actually missing from the stage (from the link).