I'm having an issue with creating a stored procedure during package install. Out of my 6 stored procedures, 5 are working correctly, but the 6th one keeps erroring out. I have three SET lines nested inside a BEGIN ... END in my 01.00.00.SqlDataProvider file.
I'm using 4.5.3 with Sql Server 2005.
BEGIN
SET @PageNumber = @PageNumber - 1;
SET @RowStart = @PageSize * @PageNumber + 1;
SET @RowEnd = @RowStart + @PageSize - 1;
SELECT RowNum,.......... etc.
When I execute the script, it errors out saying there is a problem near @PageSize. When I look at the script that is copied at the end of the error message, it has REMOVED the + signs from the script.... so it seems to be trying to execute:
BEGIN
SET @PageNumber = @PageNumber - 1;
SET @RowStart = @PageSize * @PageNumber 1;
SET @RowEnd = @RowStart @PageSize - 1;
SELECT RowNum,.......... etc.
See how it removed BOTH + signs.
When I run the SQL Script (as script) in the HOST > SQL module, it runs fine and does not remove the + signs.
Is this a bug? Any idea how to get around this?
Thanks for the help everyone.
- Brad