strange errors in execute sql task

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

Date: Thu, 1 Jul 2004 17:46:22 +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?

Relevant Pages

  • Re: Parameter for Stored Procedure
    ... Incorrect syntax near '@ClientDBName'. ... FILENAME = N''C:\Program Files\Microsoft SQL ... MAXSIZE = UNLIMITED, ... FILEGROWTH = 1024KB) ...
    (comp.databases.ms-sqlserver)
  • Re: Incorrect syntax near the keyword Close
    ... Wayne Snyder, MCDBA, SQL Server MVP ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > Incorrect syntax near the keyword 'Close'. ...
    (microsoft.public.sqlserver.server)
  • strange errors with dts and sql
    ... while executing "execute sql" tasks. ... Incorrect syntax near "1" ... uninstalling & installing sql server didn't help. ...
    (microsoft.public.sqlserver.server)
  • RE: odbccommand cant interpret some /*xxx*/ comments
    ... the odbc driver used is the one of SQL server 7 ... tnks in advance for your time! ... does anybody knows why can an odbccommand throw a "incorrect syntax near ... begin" when i try to execute something like this: ...
    (microsoft.public.data.odbc)
  • Please Help with Transaction + Alter Procedure statement
    ... I am struggling with the following SQL. ... Incorrect syntax near the keyword 'PROCEDURE'. ... Must declare the variable '@mySomething'. ...
    (microsoft.public.sqlserver)