Hi,

If I have understood your requirement correctly, this should work:

Under the destination tab of data transformation task, the connection shows " , below that it says "Table Name", there I think you can choose "Create" and use the name that you want.

Renuka__