PDA

View Full Version : MIssing SQl Scripts when converting MSI to ISM



devnksr
07-24-2008, 02:17 PM
I have a 3rd Party MSI which I know installs a Database under SQL Server 2000 and then runs several upgrade scripts against. When I convert the MSI to a ISM using the Open MSI Wizard everything seems to work successfully and I get a list of SQL Scripts under a SQL Connection however when I click on one of them I get the message,

No record found in the "ISSQLScriptImport" table for "<SQL Script Name>". Delete and recreate "<SQL Script Name>".

where "<SQL Script Name>" is the name of the SQL script.

Everything else seems to hang together perfectly as I can see all the components and the how the SQL scripts relate to them. I can also see .sql files extracted from the original MSI but I can't relate the Installer SQL Scripts to the actual .sql files.

I am currently evaluting this product as a potential method of Quality Assessing 3rd Party MSIs and this is the only area that is failing at the moment.

Any assistance would be gratefully received....

Many Thanks.

rasky74
07-25-2008, 08:13 AM
If you just need to reassociate the scripts to the file look in the ISSQLScriptFile table.