SSIS fuzzy lookup always triggers SQLDUMPER on Vista with SQL Server 2005

• mcloney

  SSC Eights!

  Points: 885

  More actions

  February 17, 2010 at 5:06 pm

  #220711

  Hi All,

  I've been scouring the 'net for a while to try to figure this out, to no avail. When my IT department finally forced us to upgrade from XP to Vista, my fuzzy lookup transformations stopped working altogether. I'm taking a single record (a varchar(2) and a varchar(255) and comparing them to two columns in a single table. The table itself has about 6000 records, but I've also tried this based on a view of only ten records, and I get the same results.

  I've tried setting 64 bit runtime to true and false, neither changes the result.

  I'm running SP2 on a clustered 2005 server.

  Thanks in advance!

  Cheers,

  -Matthew

• mcloney

  SSC Eights!

  Points: 885

  More actions

  February 25, 2010 at 1:38 pm

  #1125200

  Hi All,

  For anyone who's interested, the fix seems to be to develop your SSIS packages from a (virtual) XP machine. Sad.

  Cheers,

  -m