SSIS - How To Watch Value Of Variables During Debugging In SSIS Package


We have created a SSIS Package that takes the files from Source Folder and move them to Archive Folder. While it move them, It also add Time Stamp to file. Here is the blog post for the Package (Link) .In this post we want to watch the values of the variables at run time. This can be helpful when we are getting some errors and we are not sure if the value of variables are changed while executing SSIS Package Or our expressions are evaluated correctly that we have written on one or more variables. By looking at the value of variables, It will help us to debug our package.


We will be using Break Point in SSIS Package to view variable values at run time. Here are the variable I have used in package. I have changed the values for VarArchiveFullPath and VarSourceFullPath variables.
Expressions are written on these variable those should evaluate at run time and change the values of these variable.

Step 1: 
Right Click on File System Task and go to Edit Breakpoints

Step 2: 
Choose the Break Condition.

Step 3:
Execute your SSIS Package
Step 4:
To view the values of your variable Go to Debug--> Windows--> Locals

Let's see the values of variables win Locals window
We can see that the values are changed according to the expression and we can debug if these values are correct according to our expectations, if not then we can go back to expressions and change them. 


  1. คาสิโนออนไลน์ที่น่าเชื่อถือและมีความเป็นมืออาชีพที่สุดในตอนนี้
    โปรโมชั่นGclub ของทางทีมงานตอนนี้แจกฟรีโบนัส 50%
    เพียงแค่คุณสมัคร สล็อตออนไลน์ กับทางทีมงานของเราเพียงเท่านั้น
    สมัครสล็อตออนไลน์ >>> Goldenslot
    สนใจร่วมสนุกกับ คาสิโนออนไลน์ คลิ๊กได้เลย
    มีทั้งคาสิโนออนไลน์ หวยออนไลน์ ฟุตบอลออนไลน์ สล็อตออนไลน์ และอื่นๆอีกมากมาย

  2. very very helpfull. kindly make video on SSAS also.

  3. lovely article, my question however is, how come the value of variables on your last screen short has double \\ instead of one. After using your solution am getting that problem, and how do i fix that so it reads correctly.

  4. A huge content material as expertly as big layout. Your website deserves each one of the positive feedback its been getting. I might be promote quickly for toting taking area vibes contents. pocket watch

  5. This is very educational content and written well for a change. It's nice to see that some people still understand how to write a quality post.! shop smartwatch

  6. Thank you so much for providing information about SSIS and other APIs or controls that are mainly needed to solve the most complex and complicated technical problems.

    SSIS Postgresql Read

  7. Thank you for sharing this! What you have shared is very helpful and informative. Would love to see more updates from you.

    Melbourne Web Designer

  8. Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work. instagram likes app free coins

  9. You’ve got some interesting points in this article. I would have never considered any of these if I didn’t come across this. Thanks!. instagram likes app free trial

  10. I’ve been browsing on-line greater than three hours these days, yet I by no means found any attention-grabbing article like yours. It is pretty price enough for me. Personally, if all website owners and bloggers made good content material as you did, the net will likely be much more useful than ever before.Smartwatch Black Friday Deals

  11. I was surfing the Internet for information and came across your blog. I am impressed by the information you have on this blog. It shows how well you understand this subject. hong kong