Package stops with SQLDUMPER window

• bruno.boin

  Newbie

  Points: 9

  More actions

  May 25, 2016 at 12:00 pm

  #319036

  I already saw some topics about it, but none that could solve my problem.

  I have a package that extract information from data files using a ForEach Container, then inside a DataFlow I check if the information exists in the database using lookup and fuzzy lookups and at the end put the information on an Excel sheet and send this Excel on an e-mail.

  The problem is, to use the excel destination I had to set the Run64BitRuntime to False. But when i set it to false I get the SQLDUUMPER window stopping my package.

  If I set the Run64BitRuntime to True again it works, but the Excel Destination stop working.

  This is how my Data Flow looks:

  

  I thought of some options:

  1- Separate the 2 Fuzzy Lookups in 2 different Data Flows to see if it works

  2- Extract all the information to a Temporary table and have another package to load this information on the Excel sheet.

  3- Use a CSV destination.

  But i want to know if there are any other simpler solution for it.