This problem occurs while using the data transformations.

SOLUTION

You need to check the length of the attribute should be same at the database as you are setting in the transformation.

Please note:

1. Using scripting task, you can prepare the code to append the day when you are creating the file as a suffix to the file like File_name_ddmmyyyy.csv

2. use...

You are very right!!! in case of replication, if a failure occurs you need to get the snapshot of the whole database and then proceed....looking at this scenario, why don't...

Replication would be a good option!!!! or you may use backups and restore option