>Hi
>
>I have a file with a row lenght of 350, of which 315
>places are populated. When I do a preview of the file in
>DTS I see the correct row data BUT when I import into the
>database table it truncates the row to 270.... (the
>column length of the table is 450)...
>
>Is this a known issue, or am I doing something wrong...
>
>Thanks in advance
>Siobhan
>

>-----Original Message-----
>In article <05ce01c3b506$02b3e0c0$a001280a@phx.gbl>,
Siobhan Power
><siobhan.power@sunlife.com> writes
>>Hi
>>
>>I have a file with a row lenght of 350, of which 315
>>places are populated. When I do a preview of the file in
>>DTS I see the correct row data BUT when I import into the
>>database table it truncates the row to 270.... (the
>>column length of the table is 450)...
>>
>>Is this a known issue, or am I doing something wrong...
>>
>>Thanks in advance
>>Siobhan
>>
>
>What format is the row or source file?
>Is the row 315 characters or do you mean the column?
>What type of import are you doing, DataPump?
>What is the destination?
>Is the destination row or column 270?
>
>If the destination is SQL server and this is one column
causing
>problems, do you mean the source is 315 chars but the
destination only
>has 270 characters in that column? Are you sure it is not
a display tool
>limit? Try -
>
>SELECT LEN(ColumnName) FROM TableName
>
>--
>Darren Green (SQL Server MVP)
>DTS - http://www.sqldts.com
>
>PASS - the definitive, global community for SQL Server
professionals
>http://www.sqlpass.org
>
>.