In Control Flow create an "Execute SQL Task" ...In the task editor set the SQL Statement to TRUNCATE TABLE "yourtable"
run this before your dataflow task
I don't want to truncate the table. I want to retain the data that is there and add onto it.
Ok..we may be at last getting there (slowly) with some understanding of what you are attempting.
it seems from what you are saying that when you add your data it fails because of the constraints on the destination table...I assume you must have a unique or PK index on this table??
If that is correct (and you may tell us later that it isnt !!)...and if you are sure that you all you want to want to do is add new data then...a few ideas that just may work for you are:
either alter the source data to only provide new records
load the source into a staging table in SQL and then perform some TSQL to filter only the new data and then insert those records to your main table.
If you are going to ask us later on "how do I update existing records?."
...then I must really point you back to some of the earlier replies that you have already received that have requested that you provide more details and facts to help us help you.
Your first post in this thread said:
"Basically, I just need to know how to append records to a table via SSIS? "
I hope that you now appreciate that your question was somewhat short on detail 🙂
you can lead a user to data....but you cannot make them think
and remember....every day is a school day