Re: DTS Changing data type from numeric to decimal

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Robert salazar (rsalazar_at_cbbank.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 09:51:07 -0700

Darren, used the wizard.
Specify table copy or query: selected Copy objects and data between sql server databases.
Select objects to copy: Selected Copy Data/Replace existing data
Selected all objects

When you say did the wizard create the tables, do you mean even though the transfer contains the data and the original table structure during transfer it made them decimal? If I understand your fix, we can create the tables on the cluster were transfering too, then the DTS will apply the transfered data without defaulting to decimal.

Thanks for your help.
     
     ----- Darren Green wrote: -----
     
     What is a "basic transfer"? Did you uses the Wizard? Did the Wizard create
     the tables on the destination, I assume it must have done hence the problem.
     Only choice is to ignore it or create the tables yourself up front.
     
     I suspect it is down to OLE-DB which probably does not make any distinction,
     so when DTS says to it tell me about your structure so I can create a
     destination object that matches, it just says this is decimal.
     OLE-DB probably does not have the ability to dill down internally into SQL,
     since it is an interface at a higher level, and designed to communicate to
     different providers hence it requires a layer of abstraction. This is just
     conjecture of course.
     
     
     --
     Darren Green
     http://www.sqldts.com
     
     
     "robert salazar" <rsalazar@cbbank.com> wrote in message
     news:7EB9FC8A-6D37-44B5-9E0F-D893CC4F53FE@microsoft.com...
> Thanks for the reply, no we didn't create any new tables just a basic
     transfer. If the default is decimal how do I turn it off when transferring
     my data.
>> ----- Darren Green wrote: -----
>> If you used DTS to generate some tables then it is possible. DTS's
     table
> generation logic, appears to default to decimal.
>> I did a simple test creating a table with both, then using a DataPump
     task,
> view the SQL from the Create button on the destination tab.
>> There is no difference, in function so is this a problem?
>>> --
> Darren Green
> http://www.sqldts.com
>> "robert salazar" <rsalazar@cbbank.com> wrote in message
> news:53B9A9C2-4DB5-4E9D-BDBB-FEC2CEACC6A8@microsoft.com...
>> Help! I have a database that is in a case sensitive state, I am
     using DTS
> to transfer the database to a cluster that is case insenseitive.
     Everthing
> goes fine until I run some update scripts on the database. The srips
     are
> performing an application upgrade. I noticed on some tables the data
     typ was
> changed from numeric to decimal, my scripts do not touch these
     tables, so I
> figure it must be a setting I checked off in DTS before the transfer.
>>> Can any shed some light on what went wrong?
>>> Thanks.
>>>

Quantcast