🚀 go-pugleaf

Jody:  What's a DTS package?  It looks like you are trying to use VB syntax
for a recordset or resultset in SQL Server enterprise manager.  That won't
work.  This will (provided the cost1 and cost are currency or other numeric
datatype

Select "Answer" = (Select tblName.Cost1 + tblName.cost FROM tblName WHERE
whatever)

That might not be exactly right, but should be close.

Hope this helps


Jody wrote in message <7klvh1$2vc$1@nntp.mica.net>...
>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.
>
>--Jody
>
>