Archives
-
SQL Server Day 2009 videos now available on Chopsticks
Microsoft has made the sessions presented on SQL Server Day 2009 available on Chopsticks Opening Keynote by Wesley Backelant and Ritchie Houtmeyers Best Practices for SQL Server Consolidation by Tom Van Mulders Breaking the ETL world record with Integration Services by Henk van der Valk Designing Effective Aggregations in Analysyis Services 2008 by Chris Webb [...]
Dec 16th, 2009 | Filed under .Net, Analysis Services, BI, Event, Events, Excel Services, Integration Services, MDX, MOSS, Office, PowerPivot, Reporting Services, SQL 2008 R2, SQL Server, SQLUG.BE -
Connect to SSIS Service failed: Error loading type library/DLL
After installing SQL Server Integration Services on an existing 64-bit SQL Server, I was unable to connect to SSIS using Management Studio. The database engine and Analysis Services was already installed on this server. I added the SSIS service without Service Pack and applied SP3 afterwards. When trying to connect, Management Studio returned the following [...]
-
Import Excel files with SQL Server Integration Services on a 64-bit server
Today I deployed some SSIS packages to a test environment. These packages needed to import some excel files to a certain database. Testing the packages resulted in the following error: Error 0xc0202009: {F1B3B35C-FAE3-48F6-A169-4E4D8D99F9B6}: An OLE DB error has occurred. Error code: 0×80004005. An OLE DB record is available. Source: “Microsoft JET Database Engine” Hresult: 0×80004005 [...]
