I have SQL Server 2008 R2 on the my server, and I have this table:
CREATE TABLE [dbo].[rptost]
(
    [ID_ost] [tinyint] NOT NULL,
    [id_rpt_ost] [int] IDENTITY(1,1) NOT NULL,
    [id_rptost_q] [int] NOT NULL,
    [usrid] [smallint] NOT NULL,
    [Confirm_id] [smallint] NOT NULL,
    [date_] [int] NOT NULL,
    [time_] [int] NOT NULL,
    [date_create] [int] NOT NULL,
    [time_create] [int] NOT NULL,
    [date_read] [int] NOT NULL,
    [time_read] [int] NOT NULL,
    [usrid_create] [int] NOT NULL,
    [sycl] [smallint] NOT NULL,
    [report_type] [smallint] NOT NULL,
    [activity_no] [int] NOT NULL,
    [tedad] [int] NOT NULL,
    [price_sycl] [bigint] NOT NULL,
    [zarib] [int] NOT NULL,
    [price_year] [bigint] NOT NULL,
    [price_moavaq] [bigint] NOT NULL,
    [price_recoverable] [bigint] NOT NULL,
    [price_nonrecoverable] [bigint] NOT NULL,
    [effect_company] [nvarchar](50) NOT NULL,
    [effect_subcrib] [nvarchar](50) NOT NULL,
    [result_] [bigint] NOT NULL,
    [Financial_] [bigint] NOT NULL,
    [id_incom] [int] NOT NULL,
    [id_risk] [tinyint] NOT NULL,
    [desc_] [nvarchar](max) NOT NULL,
    [desc_analyz] [nvarchar](max) NOT NULL,
    [desc_modify] [nvarchar](max) NOT NULL,
    [desc_action] [nvarchar](max) NOT NULL,
    [desc_return] [nvarchar](max) NULL
)
I run this query on the server:
select top 5 * from rptost
and right click on the result and save into server desktop, that server SQL Server collation is this:
Polish_100_BIN
On the other side, I have SLQ Server 2014 on my client pc, I want import that csv file into my client database with sql server import wizard, but I get this error in import wizard:
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "x29" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)
How can I solve that problem? Thanks to everyone.
User contributions licensed under CC BY-SA 3.0