Akhil Madivada

Akhil Madivada

  • NA
  • 58
  • 7k

change the date in ssis package for XML file

May 23 2017 4:08 PM
Hi Developers, I am working on SSIS in my XML file I have reading dates like 2013-08-02, 2013-08-4, 2013-08-05 but I have to change the data date to from last two days, What I mean is that the data date stamp should be changed to 2017-05-21,2017-05-22,2017-05-22.

What I have tried:

what I was done is added a derived column in the SSIS package and changed the expression with GETDATE() in this case I am getting only today date, But I need to change data from last two days. Can anyone help me?
Improve question Permalink
Print Answers RSS

Top Experts