Início > Breakpoints - Variable Control, Debbuging Techniques > Watch SSIS Variable Value inside BIDS during execution

Watch SSIS Variable Value inside BIDS during execution

Link:http://pragmaticworks.com/forum/yaf_postsm57_How-to-watch-variable-values-during-SSIS-package-execution.aspx#post57

When you are running package in BIDS sometimes you may want to find out what is the value of SSIS Variables before or after execution of certain task. Perform the following steps.

Lets say you want to watch variable called varCustomerID before Step3 is executed.

1. Right click on Step3 Task
2. Select Edit BreakPoints
3. Check OnPreExecute option (Or OnPostExecute if you want to watch value after task is completed) and hit OK.

4. Now execute package. When breakpoint is hit you can bring variable watch window by opening “Locals” window (See below)

SSIS Watch Variable

Check this URL for more information on various troubleshooting techniques.

http://www.bidn.com/blog…ent-troubleshooting-tips

  1. Ainda sem comentários.
  1. No trackbacks yet.

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da WordPress.com

Está a comentar usando a sua conta WordPress.com Terminar Sessão / Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão / Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão / Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão / Alterar )

Connecting to %s

%d bloggers like this: