Hi,

I have created a mapping to update some columns in the target target Table and the connection type that is used is TPT Connections. My source and target is table (Teradata). And the job is successfull and the data populated is also as expected.

When i am trying to use an simple update query in the Post SQL of Target table and i get the above Fatal Error.

I know this update query execution can be done by creation of a new mapping/using command task/using a bteq script. But as per the design i cannot include any of these and only Post SQL.

Is it not possible to use the Post SQL when the connection type for target is TPT connection?

Please let me know why this Fatal Error occurs when i add a update query in POST SQL of Target. and how can it be implemented?

Thanks in advance