October 22, 2009 at 6:22 am
I'm trying to establish why my integration package (which picks up connections that have connections strings evaluated as expressions from user defined variables) seems to be falling over badly. It seems to be picking up a totally different file. I can only assume that somewhere within my code I've set a variable wrong, but can't for the life of me find out where. I have a for each loop container going over files in a folder and I was wondering whether there is any way I can see the value of a particular user defined variable at a particular stage (or more specifically in my for each loop) of running in debug mode. I haven't come across anything like this yet by trawling the net so any assistance would be most appreciated.
October 22, 2009 at 3:02 pm
Search Help for "debugging [Integration Services], packages" or look up how to set breakpoints and use the immediate window while debugging.
October 23, 2009 at 2:45 am
Thanks. Will have a look.
October 23, 2009 at 10:24 am
Maybe you could add the variables as derived columns in your dataflow and then use a Data Viewer ...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply