Hi,

Thanks for reply.

The problem here we need to pass the table name dynamically.It means that the procedure should able to validate all the columns what ever the table we are passing.

For this purpose we are using 'INFORMATION_SCHEMA.COLUMNS' to get the metadata details for a table.We stuck up there.

We need a procedure for which the stage,target table names should be an argument.

Hope i cleared the requirement.

Thanks in advance.

Regards,

Muthu...