problem 1: suppose i have 16 files and i want to write to destnation sql server and 13 files writes to the destination and 3 files are not written due some errors now what step i have to take to write these 3 files to destination again how to design the package. tell me in steps

In order to be able to control errors and let as many files as possible be uploaded you would need to suppress errors like this: http://sqlblog.com/blogs/rushabh_mehta/archive/2008/04/24/gracefully-handing-task-error-in-ssis-package.aspx. It seems your requirement is to fail the upload for the file that has at least one bad row. Thus, I would fail the upload on the first error, and log the name of the bad file, obviously there will be a need to resolve why it had failed, and resubmit the execution once fixed (the processed files should not be part of the re-execution). If the above is what should work for you, then I would use a ForEach Loop: http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspxArthur My Blog