May 13, 2013 at 3:05 am
Hi All,
I am getting the below error in data flow task in SSIS
Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Insert bulk failed due to a schema change of the target table."
Error message seems to be weird since there are no schema changes in source and target tables.The package has been running for months and we usually insert around 350 million records.
Please help
May 13, 2013 at 2:27 pm
If you can, RDC to the server and crack open the package in BIDS, see what it thinks the metadata changes are supposed to be. Could be something as simple as a VARCHAR() field expansion.
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
May 14, 2013 at 5:55 am
Hi Craig,
Thanks for your reply.I opened the package in BIDS but i was not able to see any errors.
Also compared the columns between the source and target and was not able to find any differences.(Datatype and Length)
What could have caused this error?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply