I was getting the error "SQL Server Integration Services Script Task has stopped working", when I set a breakpoint in a script task in Microsoft SQL Server 2005 with sp4 BIDS on a Microsoft Windows 2008 R2 sp1 x64 machine.

Error

Description:
  Stopped working

Problem signature:
  Problem Event Name:    CLR20r3
  Problem Signature 01:    dtattach.exe
  Problem Signature 02:    9.0.242.0
  Problem Signature 03:    434f5e26
  Problem Signature 04:    Microsoft.VisualBasic.Vsa.DT
  Problem Signature 05:    8.0.0.0
  Problem Signature 06:    480d5c80
  Problem Signature 07:    21
  Problem Signature 08:    1a
  Problem Signature 09:    Microsoft.Vsa.VsaException
  OS Version:    6.1.7601.2.1.0.274.10
  Locale ID:    1043

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
  C:\Windows\system32\en-US\erofflps.txt

 

image

 

Solution

Setting the [Run64bitRuntime] = False on the debugging property page, solved my problem:

– Right click you’re SSIS project in Microsoft SQL Server 2005 BIDS and click on properties

– Click on Debugging en set [Run64bitRuntime] = False

 

image

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.