Handle new field in output data

Question

Hello,

I would like to write in sql server table the data the source give...

When i use delete data and append as output option when a new field add in the source in the future,how can i handle and add automatically a new field in the destination table..

I don't want to use drop and re create as a workaround..

grazitti_sapna · Answer

Hi @Anastasio_Theohari,

I am not sure if what you are trying to achieve would be possible without dropping the table. Even if you do incremental load in this scenario, the table structure should remain the same. A new column can be added either using the drop and create or using the alter table statement. If you use alter table and create a column then you will have to find a way to add values to this column.

mbarone · Answer

You might be able to "Alter" the table using a pre-SQL statement, but I'm not familiar with that.  There may be some community posts on it.

Anastasio_Theohari · Answer

i know this but i want a simple solution except this to drop a table...Do you think there is any solution?thank you