Skip to Content
0
Former Member
Jan 04, 2016 at 07:23 PM

Passing table name dynamically in SQL Transform

182 Views

Hello Guys,

I am looking for the way to pass table name using global variable in sql transform and extract that table data into simple txt file. The challenge i am seeing is how do you update the schema of sql transform every time table is changed.Because if schema is not updated it wont match with the defined table and the job will fail. Is it possible?