I have an update statement that I run as follows from a SQL Task...

UPDATE "AS400Machine"."AS400DevLibrary"."FileName"
SET FLAG01 = 'N'

There is only ever one record on the AS400 file. I have ran this SQL
Statement from within the AS400 and it updates it fine. I run a DTS Package
to do exactly the same thing and it updates my record but mysteriously adds
another record to the file. How the interface decides to do this I cannot
find out. I have explored every avenue possible and am still no closer to a
solution.

I know I can set up globals and control them which would probably perform
well but is alot of seemingly unneccesary work and maintenance for a DTS that
is not going to grow.

Any ideas/experiences or suggestions on this are most welcome, thankyou.
marc.

What do you mean it adds another row to the file?

I am not an AS400 expert but could it be something the driver is doing?

What is you take DTS out of the equation?

Can you not call something on the AS400 to do the UPDATE from DTS instead of
issuing the statement from DTS?



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"marcmc" <marcmc (AT) discussions (DOT) microsoft.com> wrote