🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-sqlserver
Article #134

Hopefully easy question from a newbie

#134
From: Jody
Date: Mon, 21 Jun 1999 00:00
18 lines
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-mail

Show 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