Running a package multiple times

[Scott Duckworth]

I have a basic MSI package that deploys SQL Server 2000 databases. It simply copies the detached database files to the appropiate directories and runs CA's to attach the databases. I have a CA that runs early on to drop the databases if they exist. This way I can deploy updated databases. The MSI package does not show in the ARP and there is nothing to "uninstall". Is there anyway I can get the package to run again as if it was never installed when I generate a new build. I would like to keep this simple for the end user. No command line parameters, just click the setup.exe.

[LewisQ]

I don't know if this works with basic types but try this:

InstallExecuteSequence - RegisterProduct
Condition - 0

InstallExecuteSequence - PublishProduct
Condition - 0

InstallExecuteSequence - PublishFeatures
Condition - 0

AdvtExecuteSequence PublishProduct
Condition - 0

AdvtExecuteSequence - PublishFeatures
Condition - 0

We do this for standard projects and does work. Just create the release and give to the users <s>

[AUAUAU]

Luiz,

are there any other settings which need to be changed. I do have a standard project and I switched the maintenance OFF and changed the settings you indicated in your reply above. When I try and run the install a 2nd time, it runs through the GUI as expected BUT no files are transfered.

I tried this both on my main project and I created a small test project and they both have the same behaviour.

Thanks,
Anthony.