🚀 go-pugleaf

On Mon, 21 Jun 1999 14:22:25 -0400, "Jody"
<jody.finazzo@classic-co.com> wrote:

>Hi.  I'm working on a DTS package in Enterprise Manager.  What I'm trying to
>do seems like it should be simple enough, but I'm having a hard time.
>
>Here's the scenario.  I'm trying to take two fields, add them together and
>place the result in the new field.  Here's how I tried to do it:
>
>DTSDestination("costtotal") = DTSSource("cost1") + DTSSource("cost")
>
>I get the error message "type mismatch".  The data types of the fields are
>exactly the same and should be large enough to hold the data.
>
>Since I'm new at this, I thought I'd see if anyone on here could help me.
>Is my syntax correct and should I be looking closer at the data or is my
>syntax totally off?
>
>Thanks in advance for any help.

If you get the "type mismatch" error then you do indeed have atype
mismatch. If your DB firlds are the same ie "money" then you may have
to do a transformation in your code ie "CInt" or some such like.

just a thought I had the same problem with a date field and used CDate
to get it to work.

Hope this helps :)