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 |
|
yellowyellow
Starting Member
3 Posts |
 Posted - 2010-04-10 : 01:59:19
|
| I have to export the data from MsAccess database to Sql Server. One of the fields in the ms access database is memo. And the destination field in the Sql server is TEXT field. I used Data conversion in the package. Data type is "text stream [DT_TEXT]" other than this type not accepted.My problem is, in the access database there is a Unicode character (square box-for Enter key). So while transfer I am getting an error. [Data Conversion 1 [89]] Error: The "output column "Description" (113)" failed because truncation occurred, and the truncation row disposition on "output column "Description" (113)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. And also I have some other characters to validate on that field.So my requirement is whatever be the problem in the import using package, the error record should be transferred to another temp table. Successful rows should be transferred.I think we have to use Event Handlers and have to set redirect row when error occurred. I don't how to use then.Please help me how to do thatThanks |
|
|
|
|
|
SSIS Exception Handling