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 |
|
sagitariusmzi
Posting Yak Master
113 Posts |
 Posted - 2012-01-12 : 11:11:54
|
| Hi, I am trying to import data from Flat file into sql server table, but getting the error " [OLE DB Destination [112]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."The flat file contains the following columnsimage_id, image_file_path, image_filewhere image_id is uniqueidentifierimage_file_path contains unicode dataimage_file contains varbinary dataany help in this regard will be appreciated |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-12 : 12:53:16
|
| i think its because of issue in data conversion. Whats the native data type of fields as shown by SSIS? can you explicitly try to change the datatype to destination data types using data conversion task?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2012-01-13 : 00:36:04
|
| I have used data conversionand converted the data as image_file_path => DT-NTEXTimage_file => DT_TEXT |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-13 : 04:34:50
|
| what are source data types?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2012-01-21 : 02:57:34
|
| The data type of source isimage_file_path => NVARCHAR(150)image_file => VARBINARY(MAX) |
|
|
|
|
|
|
Import data from Flat File into Sql Server table