Article View: comp.databases.ms-sqlserver
Article #134Hopefully easy question from a newbie
From: Jody
Date: Mon, 21 Jun 1999 00:00
Date: Mon, 21 Jun 1999 00:00
18 lines
1397 bytes
1397 bytes
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
Technical Details
Message-ID:
<7klvh1$2vc$1@nntp.mica.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10f695,4e51240198d639f5,start X-Google-Attributes: gid10f695,public X-Google-Thread: ff490,4e51240198d639f5,start X-Google-Attributes: gidff490,public X-Google-Thread: 104de1,4e51240198d639f5,start X-Google-Attributes: gid104de1,public From: "Jody" <jody.finazzo@classic-co.com> Subject: Hopefully easy question from a newbie Date: 1999/06/21 Message-ID: <7klvh1$2vc$1@nntp.mica.net> X-Deja-AN: 492192818 Organization: Michigan Internet's Usenet News X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql,microsoft.public.sqlserver.server