Just another weblog

Archive for the ‘MS SQL Server’ Category

Mounting multiple ISOs

Posted by onlydarksets on November 17, 2008

When installing Office, etc. from our Microsoft Partner MSDN library, I usually take the lazy route and use 7-zip to unpack the ISOs.  ISODisk lets you mount up to 20 ISOs simultaneously, and it seems like a more efficient path.

Posted in Microsoft, Microsoft Office, MS Sharepoint, MS SQL Server, Windows 7, Windows Vista, Windows XP | Leave a Comment »

Another SQL Server 2005 SSIS error

Posted by onlydarksets on March 6, 2008

I posted about an error with SSIS.  I’ve gotten past that, but now I’m getting another error:

Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)

I found some information on it, but nothing helpful so far.

Posted in MS SQL Server | 2 Comments »

SQL Server Integration Services DTS error

Posted by onlydarksets on March 6, 2008

I was getting the following error when trying to create a new SSIS Package in MS SQL Server 2005 Integration Services:

Unable to cast COM object of type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass’ to interface type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90’.
This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}’
failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))..

It turns out the DTS component wasn’t properly registered.  I found the command line to fix it:

regsvr32 “C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll”

Posted in MS SQL Server | Leave a Comment »