Hello:

All I am trying to do is to create a simple table, by DTS'ing a csv file
that was created from DTS'ing data from another table. Let me explain.

I have a database named DEV1 and a database named DYNCUSTOM. I DTS'ed a
table from DEV1 to a csv file. Then, I tried to use DTS to import this table
(csv file) and in effect create a table in the DYNCUSTOM database. Upon
doing so, I got the following error:

Error 0xc02020a1: Data Flow Task: Data conversion failed. The data
conversion for column "DEX_ROW_ID" 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)

I always get truncation errors of this sort. This never happened to me in
2000. I always got this to work with no sweat. Any ideas?

When I say "DTS", I mean right-clicking on the database and choosing
Tasks...Export Data or Import Data.

I don't understand why the table that I'm importing into would have issues
with the data source. You see, the table does not exist. It's being created!
I don't understand why I could always use DTS without error in SQL 2000 but
get nothing but errors in SQL 2005.

Thanks!

childofthe1980s

Hello childothe1980s,

What is happening here is that the datatypes and/or length of the strings
do not match. This could either be between source and destination or it
could be that a value in the file itself does not fit into the defined length.
SSIS is very strict about this. The import/Export wizard will try to do
a lot for you and gets it wrong on some occasions. I helped a poster about
a month back with the Import/Export wizard and some Excel spreadsheets.

When you are setting up your Flat File connection manager to the csv file
you are given the opportunity to review/change/suggest datatypes and lengths
for the columns (Advanced Tab). Make sure these match what you think they
should be.

You say that you are creating the table in the Import/Export wizard. Make
sure the correct column datatypes are chosen here as well.

SQL Server Integration Services is the new name for DTS and it is a whole
different beast.


HTH


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com