Hi, I want to create a such SSIS Package which will export data from All table of one DB to another DB, But in importing process SSIS Package should consider the last record of all table & ignore else. Please Suggest

Use the SQL "Import and Export Wizard" to move data from one db to the other. It gives an option to save the task a SSIS package. Select that option to save the dtsx package and then manually modify the source in the package to select top1 row.http://btsbee.wordpress.com/

Hello, Even I would suggest the option of "Import/Export wizard" and you can modify the package as per your needs.