MSXML6.dll fails to register when calling SSIS from win service

Has anyone encountered this error? I get it when I run the installer (c#). I have seen a few posts on google and msdn, but still can't get past the error. I have tried uninstall/resinstalling the parser, registering from the command line, setting the property of the interop to "donotregister" and others with no luck.

Any ideas?

Thanks,
LeeOK got past the installation - but the package shows to fire but doesn't. Might be permissions; I am going to try and point the SSIS package to a local set of folders.

I think the problem was the "donotregister" property of the .dll. The SSIS tools, as you know, must be installed on your local workstation as well.

Lee|||Where are all of the 'experts' out here? I've posted five times out here and haven't received a response that remotely touches anything that I've ever come up with.

Oh well.

Still at the same place. I created another ssis package and pointed it to the local folders and ran via a console app and it works fine. Most likely permissions. Someone suggested turning logging on the package. Not sure which logging they were referring to.

Thanks,
Lee|||

Lee Everest wrote:

Where are all of the 'experts' out here? I've posted five times out here and haven't received a response that remotely touches anything that I've ever come up with.

Oh well.

Still at the same place. I created another ssis package and pointed it to the local folders and ran via a console app and it works fine. Most likely permissions. Someone suggested turning logging on the package. Not sure which logging they were referring to.

Thanks,
Lee

Package configurations. Right click on the control flow, select logging.

MSXML6 install fails

I'm having a hard time installing SQLServer 2005. msxml6 keep on failing. The log looks like this.

Installing: msxml6 on target: GPA-DEMO
Error: MsiOpenDatabase failed with 87
Failed to install package
This action is only valid for products that are currently installed.

If i try to run the MSXML6.msi on the install disk directly i'm getting a permission error. Any ideas?

Copying the files to my hard drive and replacing the MXSML6.msi file resolved the problem.|||

When I try installing SQL Server 2005 MSXML6 Always fails where do I find the log file and can you explain what you did to fix the problem step by step.

|||Ohohohohhh, naughty boy - do you think it's that easy on the Microsoft Way? Just to check the log and see what happened?
Nahhh, that's not M$; it must be more difficult otherwise you wouldn't post here, to get in touch with other frustrated admins and you wouldn't be able to vent your frustration because you wouldn't be frustrated at all... that's not good, you know, in M$ world, a liad-back admin...

Log is producedf, of course - you just cannot read it.
Isn't it great fun? Apparently due to some retarded thing or person - they are unrivaled in this field, Microsoft - by the time the path to the log is displayed the log already been deleted by the installer.
Sounds like tons of fun, right?
What? You think it's powerful stupid?
Oh noooo, you are wrong - you just need more Kool-Aid and you will realize it's THE FUN FACTOR. Yeah, this is what makes every M$ installation an unmatched challenge, it's a great fun every time...

MySQL is sooo boring - it just works, without any of these idiotic extra hops. Boring - I hate boring things, even if they work, you don't want to go there...

Now I am sorry but I have to go back and have more fun with SQL2k5 SP2 bec ause I'm having the same problem with all my selected components... good times, indeed!

|||I copied the content of the install CD to my had drive, replace the MSXML6.xmi with one i downloaded from the web and then ran the install from the hard disk. I have installed SQLServer mahy times and this was the first time it did not install.|||

I sorted my problem out by using the Windows Intall Clean Up tool. It seems that my machine had 2 versions of MSXML6 running on my machine using add remove programs was useless. If you use Windows Intall Clean Up tool to remove all traces of MSXML6 then reintall SQL SERVER it should work.

I think this is the link i used to download the tool.

http://www.softpedia.com/get/Security/Secure-cleaning/Windows-Installer-CleanUp-Utility.shtml

|||

I have also faced the same problem the Windows Intall Clean Up tool helped.

Thanks a lot for the help

MSXML6 install fails

I'm having a hard time installing SQLServer 2005. msxml6 keep on failing. The log looks like this.

Installing: msxml6 on target: GPA-DEMO
Error: MsiOpenDatabase failed with 87
Failed to install package
This action is only valid for products that are currently installed.

If i try to run the MSXML6.msi on the install disk directly i'm getting a permission error. Any ideas?

Copying the files to my hard drive and replacing the MXSML6.msi file resolved the problem.|||

When I try installing SQL Server 2005 MSXML6 Always fails where do I find the log file and can you explain what you did to fix the problem step by step.

|||Ohohohohhh, naughty boy - do you think it's that easy on the Microsoft Way? Just to check the log and see what happened?
Nahhh, that's not M$; it must be more difficult otherwise you wouldn't post here, to get in touch with other frustrated admins and you wouldn't be able to vent your frustration because you wouldn't be frustrated at all... that's not good, you know, in M$ world, a liad-back admin...

Log is producedf, of course - you just cannot read it.
Isn't it great fun? Apparently due to some retarded thing or person - they are unrivaled in this field, Microsoft - by the time the path to the log is displayed the log already been deleted by the installer.
Sounds like tons of fun, right?
What? You think it's powerful stupid?
Oh noooo, you are wrong - you just need more Kool-Aid and you will realize it's THE FUN FACTOR. Yeah, this is what makes every M$ installation an unmatched challenge, it's a great fun every time...

MySQL is sooo boring - it just works, without any of these idiotic extra hops. Boring - I hate boring things, even if they work, you don't want to go there...

Now I am sorry but I have to go back and have more fun with SQL2k5 SP2 bec ause I'm having the same problem with all my selected components... good times, indeed!

|||I copied the content of the install CD to my had drive, replace the MSXML6.xmi with one i downloaded from the web and then ran the install from the hard disk. I have installed SQLServer mahy times and this was the first time it did not install.|||

I sorted my problem out by using the Windows Intall Clean Up tool. It seems that my machine had 2 versions of MSXML6 running on my machine using add remove programs was useless. If you use Windows Intall Clean Up tool to remove all traces of MSXML6 then reintall SQL SERVER it should work.

I think this is the link i used to download the tool.

http://www.softpedia.com/get/Security/Secure-cleaning/Windows-Installer-CleanUp-Utility.shtml

|||

I have also faced the same problem the Windows Intall Clean Up tool helped.

Thanks a lot for the help

sql

MSXML6 install fails

I'm having a hard time installing SQLServer 2005. msxml6 keep on failing. The log looks like this.

Installing: msxml6 on target: GPA-DEMO
Error: MsiOpenDatabase failed with 87
Failed to install package
This action is only valid for products that are currently installed.

If i try to run the MSXML6.msi on the install disk directly i'm getting a permission error. Any ideas?

Copying the files to my hard drive and replacing the MXSML6.msi file resolved the problem.|||

When I try installing SQL Server 2005 MSXML6 Always fails where do I find the log file and can you explain what you did to fix the problem step by step.

|||Ohohohohhh, naughty boy - do you think it's that easy on the Microsoft Way? Just to check the log and see what happened?
Nahhh, that's not M$; it must be more difficult otherwise you wouldn't post here, to get in touch with other frustrated admins and you wouldn't be able to vent your frustration because you wouldn't be frustrated at all... that's not good, you know, in M$ world, a liad-back admin...

Log is producedf, of course - you just cannot read it.
Isn't it great fun? Apparently due to some retarded thing or person - they are unrivaled in this field, Microsoft - by the time the path to the log is displayed the log already been deleted by the installer.
Sounds like tons of fun, right?
What? You think it's powerful stupid?
Oh noooo, you are wrong - you just need more Kool-Aid and you will realize it's THE FUN FACTOR. Yeah, this is what makes every M$ installation an unmatched challenge, it's a great fun every time...

MySQL is sooo boring - it just works, without any of these idiotic extra hops. Boring - I hate boring things, even if they work, you don't want to go there...

Now I am sorry but I have to go back and have more fun with SQL2k5 SP2 bec ause I'm having the same problem with all my selected components... good times, indeed!

|||I copied the content of the install CD to my had drive, replace the MSXML6.xmi with one i downloaded from the web and then ran the install from the hard disk. I have installed SQLServer mahy times and this was the first time it did not install.|||

I sorted my problem out by using the Windows Intall Clean Up tool. It seems that my machine had 2 versions of MSXML6 running on my machine using add remove programs was useless. If you use Windows Intall Clean Up tool to remove all traces of MSXML6 then reintall SQL SERVER it should work.

I think this is the link i used to download the tool.

http://www.softpedia.com/get/Security/Secure-cleaning/Windows-Installer-CleanUp-Utility.shtml

|||

I have also faced the same problem the Windows Intall Clean Up tool helped.

Thanks a lot for the help

MSXML6 install fails

I'm having a hard time installing SQLServer 2005. msxml6 keep on failing. The log looks like this.

Installing: msxml6 on target: GPA-DEMO
Error: MsiOpenDatabase failed with 87
Failed to install package
This action is only valid for products that are currently installed.

If i try to run the MSXML6.msi on the install disk directly i'm getting a permission error. Any ideas?

Copying the files to my hard drive and replacing the MXSML6.msi file resolved the problem.|||

When I try installing SQL Server 2005 MSXML6 Always fails where do I find the log file and can you explain what you did to fix the problem step by step.

|||Ohohohohhh, naughty boy - do you think it's that easy on the Microsoft Way? Just to check the log and see what happened?
Nahhh, that's not M$; it must be more difficult otherwise you wouldn't post here, to get in touch with other frustrated admins and you wouldn't be able to vent your frustration because you wouldn't be frustrated at all... that's not good, you know, in M$ world, a liad-back admin...

Log is producedf, of course - you just cannot read it.
Isn't it great fun? Apparently due to some retarded thing or person - they are unrivaled in this field, Microsoft - by the time the path to the log is displayed the log already been deleted by the installer.
Sounds like tons of fun, right?
What? You think it's powerful stupid?
Oh noooo, you are wrong - you just need more Kool-Aid and you will realize it's THE FUN FACTOR. Yeah, this is what makes every M$ installation an unmatched challenge, it's a great fun every time...

MySQL is sooo boring - it just works, without any of these idiotic extra hops. Boring - I hate boring things, even if they work, you don't want to go there...

Now I am sorry but I have to go back and have more fun with SQL2k5 SP2 bec ause I'm having the same problem with all my selected components... good times, indeed!

|||I copied the content of the install CD to my had drive, replace the MSXML6.xmi with one i downloaded from the web and then ran the install from the hard disk. I have installed SQLServer mahy times and this was the first time it did not install.|||

I sorted my problem out by using the Windows Intall Clean Up tool. It seems that my machine had 2 versions of MSXML6 running on my machine using add remove programs was useless. If you use Windows Intall Clean Up tool to remove all traces of MSXML6 then reintall SQL SERVER it should work.

I think this is the link i used to download the tool.

http://www.softpedia.com/get/Security/Secure-cleaning/Windows-Installer-CleanUp-Utility.shtml

|||

I have also faced the same problem the Windows Intall Clean Up tool helped.

Thanks a lot for the help

MSXML6 install fails

I'm having a hard time installing SQLServer 2005. msxml6 keep on failing. The log looks like this.

Installing: msxml6 on target: GPA-DEMO
Error: MsiOpenDatabase failed with 87
Failed to install package
This action is only valid for products that are currently installed.

If i try to run the MSXML6.msi on the install disk directly i'm getting a permission error. Any ideas?

Copying the files to my hard drive and replacing the MXSML6.msi file resolved the problem.|||

When I try installing SQL Server 2005 MSXML6 Always fails where do I find the log file and can you explain what you did to fix the problem step by step.

|||Ohohohohhh, naughty boy - do you think it's that easy on the Microsoft Way? Just to check the log and see what happened?
Nahhh, that's not M$; it must be more difficult otherwise you wouldn't post here, to get in touch with other frustrated admins and you wouldn't be able to vent your frustration because you wouldn't be frustrated at all... that's not good, you know, in M$ world, a liad-back admin...

Log is producedf, of course - you just cannot read it.
Isn't it great fun? Apparently due to some retarded thing or person - they are unrivaled in this field, Microsoft - by the time the path to the log is displayed the log already been deleted by the installer.
Sounds like tons of fun, right?
What? You think it's powerful stupid?
Oh noooo, you are wrong - you just need more Kool-Aid and you will realize it's THE FUN FACTOR. Yeah, this is what makes every M$ installation an unmatched challenge, it's a great fun every time...

MySQL is sooo boring - it just works, without any of these idiotic extra hops. Boring - I hate boring things, even if they work, you don't want to go there...

Now I am sorry but I have to go back and have more fun with SQL2k5 SP2 bec ause I'm having the same problem with all my selected components... good times, indeed!

|||I copied the content of the install CD to my had drive, replace the MSXML6.xmi with one i downloaded from the web and then ran the install from the hard disk. I have installed SQLServer mahy times and this was the first time it did not install.|||

I sorted my problem out by using the Windows Intall Clean Up tool. It seems that my machine had 2 versions of MSXML6 running on my machine using add remove programs was useless. If you use Windows Intall Clean Up tool to remove all traces of MSXML6 then reintall SQL SERVER it should work.

I think this is the link i used to download the tool.

http://www.softpedia.com/get/Security/Secure-cleaning/Windows-Installer-CleanUp-Utility.shtml

|||

I have also faced the same problem the Windows Intall Clean Up tool helped.

Thanks a lot for the help