After calling the SQL query by
Execute Query Activity
the result is stored in
System.Data.DataTable, which inherits the column schema from core SQL Data Base, eg.
I want to clone this table to a new one:
The new table is to contain the general layout of the old table, that is: all columns and their names.
The new table must not contain restrictions on the data type it stores and values.
How can this be achieved?
I need to make changes to the data in the table. For example, convert Double (0,155) to a value expressed in % (15,5%), change the date format, etc.
After changes: new table will looks like: