I'm importing a csv and the line width is 1600 char wide
and it is not importing correctly. Each line imported is
now showing up 2 times in the destination table.

I tried to import into a single table, with single column
and then parse it. but the import will not allow me to
select a full line, there seems to be a width issue

Hi Andrew,

What is the version of SQL Server (Service Pack)? I would like you to
provide more information so that I can narrow down this issue. I am not
sure how do you configure the DTS when you import the data from .CSV file.
Please describe it in detail.

Please make sure that you perform the following steps when you import data
from .CSV file.
1. Make sure that you choose the "Microsoft Text-Treiber (*.txt, *.csv)"
option in the data source list when you import the data from .CSV file.
2. When you imported the database successfully, please try to query the
table using Query Analyzer.

I performed an experiment to import a .CSV file with a column having 1600
chars to SQL Server. Although the data showed in SQL Server Enterprise
Manager is <Long Text>, but the data is there. We can check it via
following steps using Query Analyzer.

Use <DatabaseName>
Select * from the <TableName>

--These above statements show us the data in the destination table.

Select datalength(<Column Name>) from [<TableName>]

--This statement shows us that the length of the field stored 1600 chars.

Please feel free to let me know if this solves your problem or if you would
like further assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.