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 "". Delete and recreate "".
where "" 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.
