Handle new field in output data

[Anastasio_Theohari]

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..

[mbarone]

For SQL Server, deleting and appending means deleting and appending "the data only", not fields.  So what you want to do cannot be accomplished with that option, unfortunately.  

[Anastasio_Theohari]

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

[mbarone]

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. 

[grazitti_sapna]

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.