Floating Point error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sreenath (anonymous_at_discussions.microsoft.com)
Date: 05/17/04 

Date: Mon, 17 May 2004 09:26:07 -0700

Hi,
I am executing a activex script to update the data to -999 incase the data in the source is any thing other than numeric in Activex Script of DTS

If IsNumeric(DTSSource("Col1") ) <> True Then
  DTSDestination("Col1") = -999
Else
  DTSDestination("Col1") = DTSSource("Col1")
End If

The transformation executes successfully, but after when I try to retrieve the data, I am always getting the following error. I am not sure whether it is because of DTS or any other reasons

A floating point exception occurred in the user process. Current transaction is canceled.

Any kind of help is appreciated.
Thanks,
Sreenath

Relevant Pages

  • Re: DTS Package not running
    ... Under the jobs it says executing and it can run for hours. ... When I run the job through DTSRUNUI it runs but when I schedule the ... The DTS does not period. ... >>> can run the jobs that does not have DTS package but if the job is DTS ...
    (microsoft.public.sqlserver.dts)
  • Setting sql result to global variable?
    ... .The below code is included in the "Use ActiveX Script" area of an "Execute ... SQL Task" in DTS. ...
    (microsoft.public.sqlserver.dts)
  • Re: passing variables into Activex Script
    ... /A on DTSRUN ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... then you can access this in an activex script or dynamic properties ... The batch file also passes the filepath of each file to the DTS ...
    (microsoft.public.sqlserver.dts)
  • RE: Can DTS output to variant text file names each time it runs?
    ... ' Visual Basic ActiveX Script ... "Jamie" wrote: ... I schedule the DTS to run at 10:00pm every day, ... I have to rename the output file to a different one like ...
    (microsoft.public.sqlserver.dts)
  • Re: dtsrun.exe hangs before complete
    ... there fore it would need to be whereever the package is executing. ... www.SQLDTS.com - The site for all your DTS needs. ... > DTSRun OnStart: Create table TABLE1 step ... > DTSRun OnFinish: Create table TABLE1 step ...
    (microsoft.public.sqlserver.dts)