Davy's Blog

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
High availability for BI DWH [...]

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 error [...]

Session 1: what’s new in SSIS 2008 by Nico Verheire
A word about our speaker:Nico Verheire is a Business Intelligence Consultant for RealDolmen. For the last 4 years, he has been working almost exclusively on SQL Server (7, 2000, 2005), with a strong focus on SSIS, SSAS and SSRS. Nico currently holds an MCTS certification for [...]

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: [...]