Hello:

I don't understand why I could always use DTS without error in SQL 2000 but
get nothing but errors in SQL 2005.

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?

Thanks!

childofthe1980s

I assume when you say "DTS" in your third para that you mean
Integration Services. Is that correct? I assume you mean SSIS.

The error message suggests that either you are using the wrong code
page or that length on what I assume to be strings is different in the
source data store and the destination data store.

On the General tab of the Flat File Connection Manager there is a
dropdown for code page. That will tell you what code page you are
attempting to use.

On the Advanced tab of the Flat File Connection Manager you can set
the length for string data. If you have, say, a string of length 40 in
the Flat File connection manager and a char(20) in the destination
data store SSIS will assume that the data is being truncated.

Andrew Watt [MVP]

On Fri, 14 Apr 2006 09:13:01 -0700, childothe1980s
<childothe1980s (AT) discussions (DOT) microsoft.com> wrote:

No, 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 inporting into would have issues
with the data source. You see, the table does not exist. It's being created!

Any other help would be apprciated.

Thanks!

childofthe1980s

"Andrew Watt [MVP]" wrote: