I need to develop a mapping using the SQL Transformation.

I tried to develop, everything is fine in mapping, however, I am some questions on this.

  1. The SQL script file has to be executed in some database. So, where should I provide the database connection that the sql scripts going are to execute.

          Is the target database connection, is the only one where the SQL scripts are going to execute or not?


Can anyone help me in this context.