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 |
|
on7june
Starting Member
41 Posts |
 Posted - 2007-12-14 : 04:52:34
|
| [Source - Samp_txt [1]] Error: Data conversion failed. The data conversion for column "Column 2" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".The column width for column2 is 60 and i have cross checked several times that i have created the column width as 60 in SQL Server table for the corresponding field.Sarvan |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-14 : 04:58:02
|
| Do both columns belong to same collation?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
on7june
Starting Member
41 Posts |
Posted - 2007-12-14 : 05:00:25
|
| yes both are of same data type.Sarvan |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-14 : 05:03:00
|
| No not the data type, what is the collation. Fire sp_help <table-name> for each table and check the collation of column in question for both tables.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
on7june
Starting Member
41 Posts |
Posted - 2007-12-14 : 05:07:23
|
| I am using a flat file as a source and i am loading this in to SQL Server table by creating SSIS packages. The collation shows "SQL_Latin1_General_CP1_CI_AS" for all the columns.Sarvan |
|
|
|
|
|
|
Problem in Data Flow while uploading