I am using Data flow task. In this task, I am using flat file source task to import the data to sql server destination. Data is succesfully import in to sql server tables.
Question to be done: I am having SqlRawTable. This table is having RawData field. I need to append the following text in all the records in RawData field while importing the data from flat file to sql server destination.
text to be added
1. '10.23.12.345 currentDateTime! . It should be added before the beginning of the record.
2 ' . This should be added at the end of record in sql column.
How I can accomplish this using SSIS Package importing the data from flat file task to sql server destination task.