By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,086 Members | 1,442 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,086 IT Pros & Developers. It's quick & easy.

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

P: n/a
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..

Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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..

Jul 23 '05 #2

P: n/a
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.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.