Error Packaging a script from the command line.

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings

Error Packaging a script from the command line.

Postby christiang » Fri May 02, 2014 6:15 pm

We are packaging a sql script as part of our build process. I'm using the following command:

H:\\myproject>"C:\\Program Files (x86)\\Red Gate\\SQL Packager 7\\SQLPackager.exe" /f /project MySQLPackage.sqlpkg
SQL Packager: activated, edition: professional, serial number: xxx-xxx-xxxxxx-xxxx
SQL Packager Command Line V7.0.0.1484
Copyright c Red Gate Software Ltd 1999-2013

Creating package...
Unexpected error: Value cannot be null. Parameter name: collection
Value cannot be null.
Parameter name: collection
at System.Collections.Generic.HashSet`1..ctor(IEnumerable`1 collection, IEqualityComparer`1 compa
at System.Collections.Generic.HashSet`1..ctor(IEnumerable`1 collection)
at RedGate.SQLCompare.Engine.Options.ToString()
at #4rpb.#XWA.#wVD()
at #4rpb.#XWA.#OUb()
at #4rpb.#OsPb.#6sc(String[] #ead)

Here is the sqlpackager 6 output:

H:\\myproject>"C:\\Program Files (x86)\\Red Gate\\SQL Packager 6\\SQLPackager.exe" /f /project MySQLPackage.sqlpkg
SQL Packager Command Line V6.4.0.8
Copyright c Red Gate Software Ltd 1999-2008

Serial Number:xxx-xxx-xxxxxx-xxxx

Creating package...

The project file was created in sql packager 6 initially, then when I got the error I created a new project file from sql packager 7. It seems to build fine from the UI.
Posts: 5
Joined: Tue Feb 03, 2009 7:42 pm

Postby eddie davis » Mon May 05, 2014 3:35 pm

Thank you for your forum post and sorry that you have encountered a problem.

It looks a bug to me. Therefore I have added the details of your post to Bug Report SPA-639.

I will request that the SQL Packager Product Manager review this bug report.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Return to SQL Packager 7

Who is online

Users browsing this forum: No registered users and 0 guests