It's because [I think] you are using "Normal" delimiter. So, it sees GO in the word GOTO and assumes that is the end of the block and sends that to SQL. Can you change to use Line delimiter and make sure all your GO's are on their own line?
BOb -----Original Message----- From: Artie Leech [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2008 10:56 AM To: nant-users@lists.sourceforge.net Subject: Re: [NAnt-users] NAnt sql task fails, but code works in SQL Query Analyzer Hi Bob, I tried putting a GO at the end, but I still get the same error. Any other ideas? Thanks, Artie Bob Archer wrote: > > Put a GO at the end of the file. I think that might resolve it. > > BOb > > > -----Original Message----- > From: Artie Leech [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 02, 2008 6:34 AM > To: nant-users@lists.sourceforge.net > Subject: [NAnt-users] NAnt sql task fails, but code works in SQL Query > Analyzer > > > Hi, > > I'm trying to create a nant task that will build my database, which uses > SQL > Server 2000. > > I have the following line in a loop to load up a number of stored procs. > > <sql connstring="${database.project.connstring}" delimiter="GO" > transaction="true" batch="false" delimstyle="Normal" > source="${database.ddl.filename}"/> > > It's trying to load the stored proc code shown at the bottom of this > post. > > When I run my nant task, I get the following error: > > > "BUILD FAILED - 2 non-fatal error(s), 0 warning(s) > default.build(52,22): > Error while executing SQL statement. > Object reference not set to an instance of an object." > > However, if I remove the line "IF @@ERROR <> 0 GOTO finish", from the > code > below, then the build succeeds. > > Loading the proc through SQL Server Query Analyzer works fine - it's > just > from the NAnt sql task it fails. > > Any ideas as to what I'm missing here? > > Any help much appreciated! > > Artie > > > if exists (select * from dbo.sysobjects where id = > object_id(N'[dbo].[spr_myStoredProc]') and OBJECTPROPERTY(id, > N'IsProcedure') = 1) > drop procedure [dbo].[spr_myStoredProc] > GO > > CREATE PROCEDURE [dbo].[spr_myStoredProc] AS > > DECLARE @stat int > > BEGIN > > DELETE > FROM dbo.tbl_myTable > > SET @stat=@@ERROR > IF @@ERROR <> 0 GOTO finish > > -- other stuff edited out to narrow down the nant sql error > > finish: > > RETURN @stat > END > > -- > View this message in context: > http://www.nabble.com/NAnt-sql-task-fails%2C-but-code-works-in-SQL-Query > -Analyzer-tp19776861p19776861.html > Sent from the NAnt - Users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------ > - > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the > world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > NAnt-users mailing list > NAnt-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/nant-users > > ------------------------------------------------------------------------ - > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the > world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > NAnt-users mailing list > NAnt-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/nant-users > > -- View this message in context: http://www.nabble.com/NAnt-sql-task-fails%2C-but-code-works-in-SQL-Query -Analyzer-tp19776861p19780945.html Sent from the NAnt - Users mailing list archive at Nabble.com. ------------------------------------------------------------------------ - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ NAnt-users mailing list NAnt-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nant-users ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ NAnt-users mailing list NAnt-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nant-users
