Hi All,
I have a query.
In my Source i have n numbers of files.What my SSIS package is doing its reads those files from source and load it to Db.For that i have used For Each Loop to read all Excel Files.

But mean while Out of 10 files 5 number file was failed due to Field Truncation.
How i will handle this situation.What i need i want all files to be loaded other than 5th number file and It already took 5 hrs to load till 4th file.I don't want to load again and again .How can i handle this pls suggest.

The quick and easy way is make for each loop task's Maximumerrorcount property to some number which is higher than your total number of files, say 99, or make it 0 if you want it to never fail.

and add fail sequence to the task which fails and point it to some sort of logging and move the corrupt file to some where else.

and also make sure the FailParentOnfailure property is false for this task.

There are other ways too which you can like forceExecutionResult property and scripting and logging your way out etc..

Best luck

• Edited by Idr_p 9 hours 25 minutes ago

Pls explain with some example..

by changing the data type length you can avoid the truncate field data problem.