Data Truncation error.

Hot Topic

Cannot create new SQL database file.
Change Owner Dts Package
Generate scripts only for stored procedures and views?
List of Approved Assemblies
SQL Server Express Licensing
Attempt to fetch logical page error
SQL Agent Hangs
Installing feature Pack components with an Application
Scheduled DTS package not running
Select Permission Denied on object

SQL Server

Self refrencing tree hierarchies and CASCADE actions
Changing a field background color IIF.....
How to select a case sensitive value in SQL with C#
Report Builder and custom security - can I pass credentials as a parameter?
SQL Browser service won't start
SQL Server does not exist or access denied
Another SUM limitation problem
Matrix Column Trouble
Copy databases
Retrieve SQL servers in the network

Data Truncation error.

i trying to

import a text file to a table

which has the following fields

transid int

transitem tinyint

value money

starttime datetime

info nvarchar(128)

On my text file,

i put column 0 as numeric

col 1 as four-byte unsigned integer [DT_UI4]

col 2 as currency [DT_CY]

col 3 as database timestamp [DT_DBTIMESTAMP]

col 4 as Unicode string [DT_WSTR]

then it give me

Warning 1 Validation warning. Data Flow Task: Destination - TransItem [25]: Truncation may occur due to inserting data from data flow column "Info" with a length of 128 to database column "Column 4" with a length of 50. Package3.dtsx 0 0

anyone can help

Answer this question

Data Truncation error.

JRC
on the metadata of your flat file connection source, your [DT_WSTR] has a default value of 50, change this to 128 or higher to prevent truncation of data

Kervy
EricLaw-MSFT
hehe...thanks for helping....
Data Truncation error.

Answer this question