strange errors with dts and sql

From: Alexander Nenashev (nenashev_at_hotbox.ru)
Date: 07/01/04


Date: Thu, 1 Jul 2004 17:47:27 +0300

hi.

since one time i started to encounter strange errors
while executing "execute sql" tasks.
it gives error description like this:

Incorrect syntax near "1"
Incorrect syntax near "2"
Incorrect syntax near "3"
Incorrect syntax near "4"

or something like this with different number of rows.

of cause all my datawarehouse import suffers from that.
restoring old dts packages didn't help.
uninstalling & installing sql server didn't help.

moreover i get this error also somethimes when
i run simple "select * from mytable" in
sql query anylizer.

that's a named instance of sql server.

what's happening?