I’m trying to use a dynamic parameter within a transformation task, but I can’t make it work.
It doesn’t matter how I input the Table Name, I always get the same message when executing the task: “Table XPTO to calculate dynamic parameter “Test” does not exist (yet) - using default”.
I’ve used the table name with and without schema name, with and without quotation marks, even tried with the table’s internal ID but nothing seems to work.
What am I missing?
Thank you for your help.