🚀 go-pugleaf

On Wed, 24 Nov 1999 10:01:34 GMT, yeah@right.com (Builder) wrote:

>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 :)

Jeez look at the date on that first post :). My news server must be
playing up :)