Building Packager Applikation or C# Project based on Script.

Forum for users of SQL Packager database archive utility

Building Packager Applikation or C# Project based on Script.

Postby mrupprath » Fri Jan 10, 2014 10:27 am

we tried to build a SQl Package Solution based on a SQL Script.

If i am right, SQl Packager analyses the script and crates a resource file
wich a number of Batches using "GO" T-SQL Statement for Detecting of a new Batch.

Unfortunately we run into several errors all like this "Error near GO..."
We analysed the resourcefile and found out that sometimes the Go statemens remains inside of some Batchentries of the resource file.
After we manually deleted the GO Statements, it worked.

Because this is only a suitable solution for small resourcefiles reworking the resourcefiles by hand is a bad solution.

Can someone explain how the resouzrcefile is build according to the sal script, and how to handle our Problem

Posts: 1
Joined: Thu Jan 09, 2014 4:55 pm

Postby Brian Donahue » Mon Jan 13, 2014 11:39 am

SQL Packager should be able to determine that a batch separator is present in a file and handle it appropriately. It breaks the script into lines, then checks that the line starts with GO and is on its' own line. That line will be a batch separator and Packager will not try to execute it.

Some things I guess could go wrong are... GO not being capitalized, GO not being the start of the line, or something about the end-of-line characters (MSDOS CRLF sequence is a safe bet...).
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: Google [Bot] and 0 guests