My source and destinations are Sqlserver.I need to create nearly 40 packages with different table .Some time we will get bad records from source. How to capture the
bad records? If I use redirect option in oledb destination I need to create for every table one more error table also is it good or not How to handle this situation?
View Complete Post