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 thro...
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 cases
------------------------------
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 cases
String 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).
