Thanks John...Actually I don't know all about the SSIS. So, just to get help I made that post.

For your information, I need to archive the data older than a certain...

Exactly John...I'm going to write one stored procedure to automate the archival procedure.

Can you share some idea.