onlydarksets

Just another WordPress.com 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.

Advertisements

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 »