Hi all,

I would like to explain it more clearly.

I have a table. tbl_Readings.

The table structure is as shown below,

TimeStamp, Meter1, Meter2, Meter3, .... Meter n.

1/22/2009 00:00:00 200 300 400 ..........1000

1/21/2009 00:00:00 300 400 500 ........... 700

1/21/2009 00:10:00 100 100 100 ........... 100

1/21/2009 00:15:00 100 200 300 ........... 600

1/21/2009 00:30:00 900 400 100 ........... 200

I have the values like this. What I have to do is. .. I have to fetch yesterday's data , and store it in a new table. The condition here is I have to fetch yesterday's data, with 15 minutes gap in between. i.e, First row to be fetched is 1/21/2009 00:00:00, next row to be fetched is 1/21/2009 00:15:00, next row should be 1/21/2009 00:30:00. I have to do this using SSIS.

How to do this?

Please help me.

Thanks.