Debug Scripting task

Scripting Task
Scripting task in SQL Server 2005 take full advatage of VB.net and dramatically extended the capability of SSIS pacgkage. However if you use SQL Server 64bit edition, you may get the following error message in the Microsoft Visual Studio for Applications when test you package in the VSBID.
( Microsoft Visual Studio for Applications has lost the link to .
Your work will be exported to C:\Documents and Settings\…. when you quit the application )
 
This is because Microsoft Visual Studio for Application does not support 64bit. When the package is running under 64bit, SSIS service can’t find the necessary files.
If you run the package in debug mode and do not have breakpoint in the VB.net code , you can:
1) Go to the scripting task property and change the property "PreCompile" to true
2) Edit the scripting task–>Script tab–>Design Script… to open Microsoft Visual Studio for Application, go to Debug menu and select Build and save your work.
 
However, if you have breakpoint and want to debug the VB.net code, you will still get the above mentioned error.
To debug the scripting task code, in the solution Explorer in VSBID, right click your project and open the Property Pages, Select the Debuging tab in the Configuration Properties in the left pane, and expand the Debug Options in the right pane and change Run64BitRuntime from true to false.
 
Now you can successfully debug your VB.net code of your scripting task. The PreCompile property of the Scripting task does nto matter anymore, it can be set to True or False.
 
 
Advertisements
This entry was posted in SQL Server SSIS. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s