November 19, 2008 at 9:01 am
Hi guys,
today I set my foot into the brave new world of the SSIS 2008 Dataflow Script Component. To my total astonishment I found that I don't have to use ugly VBA but that the environment works with C# now - that's cool!
Not so cool: I set the first breakpoint and tried to find out how things work - but a messagebox tells me that
"You can not debug or run this project, because the required version of the Microsoft Office application is not installed"
On the machine there is a Microsoft Office 2007 RTM full install. I can't just go and try installing SP1 (because the machine is my clients') - so could please anyone experienced tell me if wheter that really is the solution or if there is something else to be done about the issue?
Thanks in advance and cheers,
Juergen
April 13, 2009 at 2:17 pm
Did you happen to find the solution for this?
April 13, 2009 at 10:51 pm
Hi Mark,
well, sort of: It was a RTFM problem... You simply can't debug in the data flow. Microsoft states it in several BOL documents as well as in the product docuentation. I dont have a URL at hand, sorry.
Cheers,
Juergen
April 13, 2009 at 11:17 pm
To be more constructive - this is how I developed the component. The problem was to accumulate some rows (sales data) until a 'footer' row showed up, then do some calculations and send the data to different outputs depending on several conditions.
- Getting rid of coding errors / finding unexpected data: I catched all exceptions and sent the trace stack to a special output along with parts of the data to identify the problems. You can avoid this by in-depth knowledge of the data and by error-free coding 😉
- Make sure the data goes to the correct output and the calculations are accurate: I generated some good old test cases.
HTH,
Juergen
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply