How to insert column name in the destination table in ssis?

CREATE TRIGGER `TestResult_BEFORE_INSERT_1`
BEFORE INSERT ON `TestResult` FOR EACH ROW
set new.Experiment_Name = (
    select Experiment_Name
    from TestExperiment
    order by Experiment_id desc
    limit 1
);

DELIMITER //

CREATE TRIGGER `TestResult_BEFORE_INSERT`
BEFORE INSERT ON `TestResult` FOR EACH ROW
BEGIN
  DECLARE v_id INT;
  DECLARE v_name TEXT;

  SELECT Experiment_id, Experiment_Name INTO v_id, v_name
  FROM TestExperiment
  ORDER BY Experiment_id DESC
  LIMIT 1;

  SET new.Experiment_id   = v_id;
  SET new.Experiment_Name = v_name;

END //

DELIMITER ;

ALTER TABLE DataDest
ADD CreateDate DATETIME 
CONSTRAINT DF_DataDest_CreateDate DEFAULT (GETDATE());