.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Unable to debug Script Task in SSIS

Posted By:Raga       Posted Date: November 12, 2010    Points: 50    Category: DataBase    URL: http://www.dotnetspark.com  

This is an issue that's commonly faced while developing SSIS Script Task and Script component where we want to debug the Script component and fail in that. Below is the reason and Solution for the same.
 

If you are unable to debug your script even after setting a break point, You need to check the below.

Is your script task in Control Flow or Data Flow ?

  1. Script can be written in Control Flow using "Script Task".
  2. Script can be written in DataFlow using a  "Script Component".

We cannot debug script in DataFlow Task.

You can debug the script task in control flow by setting a breakpoint , But the same is not possible for a Script Component. Instead you can use MsgBox command to view that particular value.

You can also add DataViewers to view the output data.

If you need a particular reason for this.. Here are not accurate but supporting points..

1. Script Component can act as Source, Transform and Destination. So it's not secure to allow debugging for such sensitive Data.

2. Microsoft has not yet provided this feature . We can expect this in future releases. (Simple answer)

 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend