View Single Post
  #7 (permalink)  
Old May 16th, 2007, 08:38 AM
jilly jilly is offline
Authorized User
Points: 209, Level: 4
Points: 209, Level: 4 Points: 209, Level: 4 Points: 209, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2005
Location: , , .
Posts: 49
Thanks: 0
Thanked 0 Times in 0 Posts
Default

On the pane on the left (two tabs, Language and Browser) you can double-click on the available global variables and it will paste the correct reference into your code.

Turn on just-in-time debugging and step through your code to make sure you're referencing the variable correctly. (Right-click "Data Transformation Services" in Enterprise Manager and there's an option to turn on Debugging.)

Then within your code place a STOP statement and it will break during execution. SAVE your package before debugging. The debugger will always (?) close Enterprise Manager after you're done debugging.

Nothing in your code off-hand looks odd. Your options to do what you want are to add an ActiveX script within the workflow properties, or to, as you're trying to do, use a pass/fail condition to branch.

SQLDTS.com has additional information that you may find helpful.

--Jeff