Table Creation in SQL server with specific data type using data from excel file

Hi @Marley_Bacelar,

If you want all the columns included in each table, then you can use a copy snap (File Reader → Excel Parser → Mapper → Copy). Intentionally kept a mapper before copy so that you can add/remove any additional columns for your table.

You can refer to this page for changing data types, screenshot below for your reference:

Please ensure that you have multiple outputs enabled in your copy snap (can be achieved by clicking the snap itself and then going into the views). Screenshot below for reference:

After the copy snap, you can have another mapper snap for each output if you need to do any transformation and then have your target system snaps attached to each copy/mapper snap (if you used mapper snap after copy snap). Screenshot below for your convenience.

Thanks!