Hi All,

Even i am also facing the same problem, Any quick response is helpfull.

Thank you,:-)

Thanks for the immediate reply.

Step 1 can be done by using Execute SQL Task.

Please let me know how EXecute SQL Task can be used to do the Step 2 and...

Hi,

how can we perform this using SSIS.

i think:

Connect to a Data source and using Execute SQL Task With Command INSERT INTO dstn_table FROM src_Table WHERE DATEDIFF(days, [OrderedDate], getdate()) <365

thanks

Jeevan