I have several queries that were part of a DTS package in the old SQL 2000 system. This database is migrating to 2005, and I am having to re-build the function. Mostly it hasn't been a problem, except for a series of SQL query groups that necessarily declare variables. When viewing the query in Business Intelligence Development Studio, it gives me this error:
"The Declare cursor SQL construct or statement is not supported."
Then the query is displayed, and (for example) the first line in the original SQL 2000 query:
Declare @i int
Appears like this in the SQL editing window:
DECLARE ? int
All the variable declarations in the query package are displayed like this, as if SQL 2005 cannot process the variable declaration, however nothing I've found on the Microsoft site or anywhere else suggests that variable declarations are handled any differently in sQL 2005 than they were in 2000.
Any ideas?
"The Declare cursor SQL construct or statement is not supported."
Then the query is displayed, and (for example) the first line in the original SQL 2000 query:
Declare @i int
Appears like this in the SQL editing window:
DECLARE ? int
All the variable declarations in the query package are displayed like this, as if SQL 2005 cannot process the variable declaration, however nothing I've found on the Microsoft site or anywhere else suggests that variable declarations are handled any differently in sQL 2005 than they were in 2000.
Any ideas?
