August 21, 2007 at 7:33 am
Hi Everyone
Iam new to SSIS. I have a Execute SQL task that runs a cursor to insert values into a db.
The package fails because of bad data (i suspect) and iam trying to see what the value is of the paramater that makes my SQL statement dodgy: For example : Select * from Employer where lastname = @Lastname. How can i know what the last value passed to the paramater was that made this bomb?
August 21, 2007 at 8:26 am
I have had this issue a number of times.
And it seems SRS doesn’t have any good tools or capability to find the values of the parameters. If only the local’s variable window would work…
The trick I use to get around this is creating a text on the report to display the value. If the error is occurring before the report is generated, you can display the value in another parameter. (Basically create a new unbound report parameter as a string and the default value will be the value(s) you are item you’re trying to debug.)
Its kind of crappy to do a work around like that, but its all I have found…
August 21, 2007 at 12:58 pm
Is it a SSIS or SSRS problem? If the former, then you could try adding an event handler for the taskfailed event, or even for the variablevaluechanged event, and then in the event handler write out the variable value(s).
HTH,
Steve.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply