Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2008-08-08 : 11:38:41
|
Hi,I have a package which was created programatically. This packages connects to a Sybase server (Source) and Sql Server (Destination).This package has been like 2 months with out any issues. All of sudden it started failing with the below error. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL NativeClient" Hresult: 0x80004005 Description: "Unable to resolve columnlevel collations. Bulk-copy cannot continue.".Failed to open a fastload rowset for "db..tbl". Check that the object exists in the database."component "OLE DB Destination" (16)" failed validation and returned validation status "VS_ISBROKEN".One or more component failed validation.There were errors during task validation. Even though the error says its Column collation issues, I do not think it is the case due to the following reasons:1. This has been running fine all these days, with the same setup.2. There was no change in either source/destination3. If I remove the fast load option, then the same package works. 4. Dropping / Re-creating the table in Sql Server also seems to do the trick. I cannot do this in Prod enviornmentSo, any idea, Why would a same package fail, when fast load option is selected and succeed when it is not selected.ThanksKarunakaran |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-09 : 02:31:48
|
| I think one thing you can do is to use SQL Profiler and capture difference in commands passed to db from SSIS in both cases. Try if you could pick something strange happening in case of fast load. |
 |
|
|
|
|
|
Fast Load Fails