Comments by Akhil Madivada

Akhil Madivada 24-May-17 11:31am View

created SSIS packages in data flow connecting XML source and the OLEDB destination and in the middle of this two transformations I placed a derived column transformation and added an expression GETDATE() in this case the dates in the data are changing to today's date but I but to change in a sequence from last days.

Akhil Madivada 24-May-17 11:05am View

Thank you for your reply, Here is my sample XML file data with timestamp,
<Reading TimeStamp="2013-08-02 03:45:00" RawReading="229.9"/>
<Reading TimeStamp="2013-08-03 00:00:00" RawReading="0"/>
<Reading TimeStamp="2013-08-04 18:30:00" RawReading="0"/>
<Reading TimeStamp="2013-08-07 20:15:00" RawReading="0"/>

I have to change the timestamp date from 2013-08-02 to 2017-05-21, 2013-08-03 to 2017-05-22, 2013-08-04 to 2017-05-23 and 2013-08-07 to 2017-05-24. this changes I have to do by using SSIS and my destination is OLEDB.

Akhil Madivada 24-May-17 11:04am View

Thank you for your reply, Here is my sample XML file data with timestamp,
<Reading TimeStamp="2013-08-02 03:45:00" RawReading="229.9"/>
<Reading TimeStamp="2013-08-03 00:00:00" RawReading="0"/>
<Reading TimeStamp="2013-08-04 18:30:00" RawReading="0"/>
<Reading TimeStamp="2013-08-07 20:15:00" RawReading="0"/>

I have to change the timestamp date from 2013-08-02 to 2017-05-21, 2013-08-03 to 2017-05-22, 2013-08-04 to 2017-05-23 and 2013-08-07 to 2017-05-24. this changes I have to do by using SSIS and my destination is OLEDB.

Akhil Madivada 20-May-17 1:43am View

yeah you right SSIS does XML but finding difficult in creating packages for my XML data ,I need output with metername ,serial number,meterreadingid,medaitype,installdate from XML data. I don't know how to create package in SSIS can you please help me on that.
Thank your for your response.

Comments by Akhil Madivada (Top 4 by date)