Ran into this today on my laptop. Fired up BIStudio to test some SSIS packages on my local machine.  I couldn’t even load the package due to the LoadXml error mentioned above complaining about the FLATFILE provider.  Come to find out this has to do with something, LEXMARK printer drivers and Flash 8 are suspects, mucking with the security around component categories.  I found some code that when run as a low privileged user will find the bad entries:

using System;
using Microsoft.Win32;

namespace CheckClsidPerm
{
    class Program
    {
        static void Main(string[] args)
        {
            RegistryKey clsid = Registry.LocalMachine.OpenSubKey(@"Software\Classes\CLSID");
            string[] clsids = clsid.GetSubKeyNames();
            Console.WriteLine("found {0} keys", clsids.Length);

            foreach (string s in clsids)
            {
                try
                {
                    using (RegistryKey clsidKey = clsid.OpenSubKey(s))
                    {
                        using (RegistryKey ic = clsidKey.OpenSubKey("Implemented Categories"))
                        {
                        }
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine("error while reading key {0}: {1}", s, e.Message);
                }
            }
        }
    }
}

Run this under a low privilege account.  Then go in and find the CLSIDs in HKEY_CLASSES_ROOT and add Users with read access.  This fixed the issue for me.

Tuesday, May 16, 2006 11:43:02 AM (Pacific Standard Time, UTC-08:00)         Comments [1]