IMPORTANT :Move Error file to Destination Folder
I have set the Maximum Error Count=0 to all components except the Checkfail container. It behaved as Expected,..Thnks for your repliesRakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/
August 5th, 2011 2:18am

Hi Team, I have Concern in my Package. I have a Excel as a source which loads the Data to a Table which has a Primary Constraint so no dupilate are inserted. What is the Required Flow is if the Excel contains any error [duplicate] then has to be moved to a error folder and Rest of files has to be Processed. The Number of files and error files per day varies[1 ~25]. But,the Problem is the DFT which extracts fails due to duplicate Row then entire Package Fails which should not Happen. I Have set the Maximum Error count on All components =1 and Fail Parent on Failure and Fail Package on Failure to False. What will be the reason for this...Kindly let me know the Solution. Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2011 4:07am

Hi , When you introduce a "OLEDB Destination Adapter" , Go to the "Error Output" Section. Set the Properties i. If you would like to See the Error Records : Set as Reditrect Rows property ( and you can use Error Destination File to cache the Redirect Rows) Or If you would like to Ignore the Errors, Set as "Ignore Failure" rajiv
August 5th, 2011 4:34am

Thanks for the Reply, I need to Have it as Fail Component and cant re-direct the rows as we are not capturing this data.Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2011 4:41am

If you Don't Capture Data, u could set to "Ignore Failure" ,Sice this allows the entry (for primary key) to be inserted and AVOIDS the package to fails for duplicate entriesrajiv
August 5th, 2011 4:59am

you can use CONFIGURE ERROR OUTPUT to redirect bad data rows like rows which violates the unique constraint or ignore them, this is sample of using CONFIGURE ERROR OUTPUT to redirect bad data rows: http://www.rad.pasfu.com/index.php?/archives/23-How-to-handle-Failed-Rows-in-a-Data-Flow.htmlhttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2011 5:09am

I have Concern in my Package. I have a Excel as a source which loads the Data to a Table which has a Primary Constraint so no dupilate are inserted. What is the Required Flow is if the Excel contains any error [duplicate] then has to be moved to a error folder and Rest of files has to be Processed. The Number of files and error files per day varies[1 ~25]. But,the Problem is the DFT which extracts fails due to duplicate Row then entire Package Fails which should not Happen. I Have set the Maximum Error count on All components =1 and Fail Parent on Failure and Fail Package on Failure to False. What will be the reason for this...Kindly let me know the Solution. >> IS this you looking for : Try to Set ForceExecutionResult : Success HI * Edit : set this property for every component [Except Dataflow (which on failure you want to do your File movement task Leave this property to NONE) rest set true all tasks for each , Sequence containes + the package property at control flow level ] But i hope you have logging enabled properly as there can be failures out of dataflow that would be forced to success and you might not have trapped those scenarios .... Hope that helps ... Kunal
August 5th, 2011 5:36am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics