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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2009-11-19 : 07:43:27
|
| Dear All,I am trying to importing the data from flat file to Table.While doing so i am getting error.I am not sure why exactly it is so,pls help in resolving this error.[OLE DB Destination [9]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification". Also if i change the column datatype from Int to varchar,it is loading data successfully..Any help in this regard.Thanks,Gangadhar |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-11-19 : 07:54:41
|
| well I'd guess that you have a value in the column that can't be cast to an INT.check the data.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2009-11-19 : 08:03:04
|
| I checked the column thoroughly...the data is fine...but for some row data is null..The same issue is coming for other column which are having datetime format.Please help,Thanks,Gangadhar |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-11-19 : 08:49:52
|
| do you mean that you have the STRING 'NULL' in the file.If this is a csv or other flat file then NULL in the file will be treated as it's character value 'NULL'Do a find replace and replace the 'NULL' with the empty string.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2009-11-19 : 08:55:51
|
| Hi,Thanks for your help.I did the changes to source file datatype in the connection manager and its worked out for me.Any how thanks for your help.Thanks,Gangadhar |
|
|
|
|
|
|
|
|
Error with Flat file