December 14, 2012 at 6:29 am
I am trying to run an SSIS package and I get the following dialog when I execute:
"There were Build Errors. Would you like to continue and run the last succssful build?"
An advice? What exactly is a build error?
thanks.
December 14, 2012 at 7:02 am
There is a fault in the ssis package and it won't run.
It should give you error messages about the build.
Which version are you usoing?
Cursors never.
DTS - only when needed and never to control.
December 14, 2012 at 7:13 am
2008, it gives no error details that I see. What happens if I select Yes?
December 18, 2012 at 2:51 pm
Selecting yes will run the package with the last successful configuration. It is kind of like Windows restore.
December 18, 2012 at 2:58 pm
Export the package to a dtsx file and get it into BIDS/VisStudio. You need to see what the problem is. Usually it's a schema modification screwing up metadata or something.
The statement in question is trying to go into the version history of the package to find one that works. You don't want to do this, developers have adjusted the package for a reason. You want to fix the current one.
A build error, as mentioned, is basically something's no longer valid in the compile. Because Metadata is part of the compilation and not dynamically found, that's usually the culprit, but it could be a missing script inclusion or awol dll just as easily. Check for the obvious first, get it into BIDS and go from there.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply