This is a requirement. What is your question?

You've tried the file system task, I presume?

Apologies if you've already answered this question, but is the package deployed to SSISDB?
If so, can you check the 'All Executions' report for the package to see whether that...

Have you tried casting to VARCHAR() and then doing the comparison?

Something like this, maybe:
WITH SourceData
AS
(
  SELECT
   ID   = ID
  ,  EMPID  = a.SNO
  ,  TYPE   = '1'
  ,  ACTIVATE = a.StartDate
  ,  DEACTIVATE...

Are you saying that you have data stored in a column and you want to get all of the column's items into a string variable as a comma-delimited string?

Aside from change tracking, you can do this only if you have two tables, one containing 'old' data and one with the current data.
But if all you have is...