Building Packager Applikation or C# Project based on Script.

mrupprath

Hello;
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

Greatings.

Brian Donahue

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...).