DSXchange

Handle what by itself? Using a job parameter for the schema name? Both of these suggestions just go in the 'Table Name' box, no need for user defined sql just for that.

Now I got what you mean, while 'Build'ing the sql, in the 'Table Name' option we can give the parameter.
Thanks for this.

Yup, exactly.

And rather than use the 'SQL Builder tool' to create your source queries, I much prefer the 'Generate SELECT clause from column list; enter other clauses' way of doing things. I wouldn't touch the Builder with a thirty-nine and a half foot pole. That long 'Generate' option is what used to be called simply 'Column Generated' in the earlier versions.

Save the user-defined or custom sql for those times when you have absolutely no other choice.