SQL Server Performance

how to fail a enitre package in ssis

Discussion in 'SQL Server 2005 Integration Services' started by abhisek, Aug 3, 2009.

  1. abhisek New Member

    I have a package which will tranform a data from one table to another. In case if there is an errror on a records it will dump that error on flat file, and if error exceeds more than 50 then the entire packagae should fail. I used conditional split by creating variable rowcount, but when error exceeds more than 50 my package doesnt fail instead it will copy all the errors which are more than 50 on a flat file. do any one have an idea to fail a package if the condition doesnt meet.

  2. MohammedU New Member

Share This Page