Hi,

I receive an overflow error when I execute a package.
But what is strange my source has not changed and this morning the package
works fine.
and now I've the error.

and I've change NOTHING on this package, and the data source is exactly the
same!

I've executed this package 20 or 30 times before without any error.
and its the first time with this error.

also, the error says "convert from numeric to numeric" and I've no numeric
column type in this loading process, the only decimal typed column is set to
0 and not filled by the package.

any idea???

Thanks.

Jerome.

The way I approach problems like this is to use the error logging of rows
ability in SS2K DTS and see which rows with which the package is having
problems. Short of that I would start to restrict the rows I send over each
time and see when she blows.

Could this problem be with transient data?



"Jéjé" wrote:

Its ok, I've found the problem, but I've no real answer because this query
has run for 4 months without any problem, and today only I have a problem !

my query is like this:
select * from table
where TestID in (4,10)

TestID is a decimal (4,1) type
if I change the query to :
my query is like this:
select * from table
where TestID in (4)

then all works fine!!!!

but I don't understand why during 4 months the first has worked correctly!
(near 200 executions)

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote