SSIS

• lzlzgh

  SSC Enthusiast

  Points: 131

  More actions

  September 17, 2009 at 11:18 am

  #135715

  I was using a sample from book to populate a dimension. I am using a staged dimension with a lookup and using an error output to add new dimensions. My question is that in the example I added duplicates to the staged dimension which create's duplicates. Do you handle this type of error by utilizing a distinct in the select statement.

• Erik Kutzler

  SSCarpal Tunnel

  Points: 4287

  More actions

  September 17, 2009 at 12:11 pm

  #1055187

  Without knowing the details of your sql statement, I would say yes, add DISTINCT to attempt to resolve the duplicates.