Using DTS to move data to a new table with some datatype changes

[tdmailbox]

I have a production application that I am building some upgrades using
a second (empty) copy the database. A few of the upgrades included
changing the datatypes of a few fields from varchar to int(all the
values in this column are already numbers)

I am not trying to move the data from the production database into the
blank database using DTS and the fields that had their datatypes
changed are getting dropped by dts.

Is there anyway to move this data easily through dts or through another
method and not have the fields with the datatype changes get dropped?

I have about 60 tables so it is not as simple as just copying and
pasting the data..

[John Bell]

Hi

I can't see why this would be happening. What you may want to try is using a
SQL Statement as the data source then you can cast the column to the new
datatype or possibly using the same datatype and issue an alter table
command afterwards or just changing your live table to start with!

John

<td*******@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

I have a production application that I am building some upgrades using
a second (empty) copy the database. A few of the upgrades included
changing the datatypes of a few fields from varchar to int(all the
values in this column are already numbers)

I am not trying to move the data from the production database into the
blank database using DTS and the fields that had their datatypes
changed are getting dropped by dts.

Is there anyway to move this data easily through dts or through another
method and not have the fields with the datatype changes get dropped?

I have about 60 tables so it is not as simple as just copying and
pasting the data..

[Joško Šugar]

td*******@yahoo.com wrote:

I have a production application that I am building some upgrades using
a second (empty) copy the database. A few of the upgrades included
changing the datatypes of a few fields from varchar to int(all the
values in this column are already numbers)

I am not trying to move the data from the production database into the
blank database using DTS and the fields that had their datatypes
changed are getting dropped by dts.

Is there anyway to move this data easily through dts or through another
method and not have the fields with the datatype changes get dropped?

I have about 60 tables so it is not as simple as just copying and
pasting the data..

Check the source and destination tab in your transform data task. The
problem you described happened to me when I tried to migrate DTS
package. It had the old table as destination table.