Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data flow task error in SSIS Expand / Collapse
Author
Message
Posted Monday, May 13, 2013 3:05 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 15, 2014 11:47 AM
Points: 50, Visits: 222
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
Post #1452008
Posted Monday, May 13, 2013 2:27 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 2:26 PM
Points: 5,466, Visits: 7,647
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.


- Craig Farrell

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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1452314
Posted Tuesday, May 14, 2013 5:55 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 15, 2014 11:47 AM
Points: 50, Visits: 222
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?
Post #1452523
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse