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