Forum Discussion
I installed SSMS 2022 express and when I am trying to import data its throwing errors
TITLE: SQL Server Import and Export Wizard
------------------------------
The operation could not be completed.
------------------------------
ADDITIONAL INFORMATION:
External component has thrown an exception. (System.Data)
------------------------------
BUTTONS:
OK
------------------------------
this is the error
and some more errors also came and I resolved with too much hectic but this error I am not able to with this error
can you anybody help me with this
- TITLE: Microsoft SQL Server Management Studio
------------------------------
Error inserting data into table. (Microsoft.SqlServer.Import.Wizard)
------------------------------
ADDITIONAL INFORMATION:
Error inserting data into table. (Microsoft.SqlServer.Prose.Import)
------------------------------
The given value 'ãCqœO–(Žë»(æÇy–õ·õ¬?Çúdeý¡8Î'Kˆ†÷øóܸÓùyUéÙC'˜Eým=êű>Y9|(ŽóÉÅq]%‚Y9Ù®‹ ó‡âX›¬ @ÇÙd ⸦‹Á' of type String from the data source cannot be converted to type nvarchar for Column 0 [column1]. (Microsoft.Data.SqlClient)
------------------------------
String or binary data would be truncated in table '[dbo].[Campaign data]', column 'column1'. Truncated value: 'ãCqœO–(Žë»(æÇy–õ·õ¬?Çúdeý¡8Î'Kˆ†÷øóܸÓùyUéÙC'˜Eým=êű>Y9|(ŽóÉÅq]%‚Y9Ù®‹ ó‡âX›¬ @ÇÙd ⸦‹Á'. (Microsoft.Data.SqlClient)
------------------------------
BUTTONS:
OK
------------------------------
the above is with respect to flat file import option
whether I should import developer addition uninstalling the current version?
32bit 64bit also not worked all the casesString or binary data would be truncated in table '[dbo].[Campaign data]', column 'column1'.
YukeshKumarSunkara , as the error message, clearly says, you can not import larger data then allowed by the table column definition, it would be truncated.
"Re-installing" won't change anything on this.
Clean up source data or change column definition (data type, size).
