Davy Knuysen

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: 0x80004005.
An OLE DB record is available.  Source: "Microsoft JET Database Engine"  Hresult: 0x80004005  Description: "Unspecified error".
 

Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "DestinationConnectionExcel" failed with error code 0xC0202009.

It seems there just isn't an 64-bit version of the JET OleDb driver for Excel and because the test server was a 64-bit, this caused the Excel-import to fail.

• To make the package work using BI-studio you need to change your project debugging properties: Set Run64BitRuntime to False
  
  
  
• To make the package work when started from a SQL Server Agent Job, you need to execute the package using the 32-bit version of DTExec.
  To do this create a Operating System Job Step and type the command to execute the package using DTExec in the 32-bit folder: C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\

The complete commmand will be something like this:

C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe /DTS "\MSDB\Import" /SERVER "." /MAXCONCURRENT " -1 " /CHECKPOINTING OFF  /REPORTING V

Good luck!

The newest version of MDX Studio, now also has intellisense!

With Visual Studio and other modern IDEs, Intellisense became a must have tool in the developer’s toolset, boosting productivity. MDX developers have asked for it, but full, context-dependant intellisense wasn’t available. Until now. MDX Studio now features comprehensive support for intellisense. The first version with usable intellisense support is 0.4.4....

More info: http://sqlblog.com/blogs/mosha/archive/2008/08/22/intellisense-in-mdx-studio.aspx 

Download: http://cid-74f04d1ea28ece4e.skydrive.live.com/browse.aspx/MDXStudio/v0.4.4

REDMOND, Wash. — Aug. 6, 2008 — Microsoft Corp. today announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence platform. This version of SQL Server provides powerful new capabilities such as support for policy-based management, auditing, large-scale data warehousing, geospatial data, and advanced reporting and analysis services. SQL Server 2008 provides the trusted, productive and intelligent platform necessary for business-critical applications.......

Read more here.

I justed wanted to share this interesting article:

With new compression, partitioning and star schema optimization features,
Microsoft's SQL Server 2008 is catching up with the state of the industry in data warehousing.
Here's why these three capabilities are crucial for scalability and performance on any platform.

By Warren Thornthwaite

Read the full article here.

Want to check your MDX for best practices?

You should! Check this MDX Analysis tool: MDX Studio (0.4)  by Mosha

Community Day 2008 was again a great succes!

You can watch the recorded sessions under the download category Sessions on www.communityday.be

When you try to create a data source in the Performance Point Dashboard Designer and you get this error message, it probably meens that you did not have the Ajax extensions installed.

You can download the setup file here: ASP.Net 2.0 Ajax extensions 1.0

The Belgian community has a very strong reputation internationally with many individuals making their mark in their fields of expertise. Lots of individuals, just like you, are hungry for more information about the many Microsoft products and technologies. In addition to the technical information, there is also very often the need to just socialize with other persons within the same domain of expertise. The many user groups that were started the last couple of years are doing a great job trying to address these needs with monthly meetings.

Eight of them, Belgian Dynamics Community, Biwug, IT-Talks, Pro-Exchange, SQLUG, Visug, Winsec, and XNAbug have decided to combine their efforts again to organize another joint-event just before summer starts. So if you are eager to learn, get answers to your questions and meet your peers, come and join us at the premises of SemCom in Keerbergen on Thursday, the 26th of June 2008.

More here.

"Managing, monitoring and troubleshooting SQL Server using Free tools" given by Dirk Gubbels (Microsoft)   

Abstract:
Out of the box, SQL Server 2005 offers nice tools for managing and monitoring servers and databases. If you want to get an even richer experience and a broader toolset, there are a lot of hidden gems out there, free for you to download and to make the life of the DBA easier. This practical and demo-driven session will show you how to make best use of some of these. Topics include: Extending Management studio with custom reports, Performance dashboard, Sqlio, Dmvstats, RML Utilities and more...

Level: 300

Date: Thu May 29, 2008

Agenda:
18:00 - 18:30 Welcome with a drink & sandwich
18:30 - 20:00 Part 1
20:00 - 20:30 Pause
20:30 - 22:00 Part 2
22:00 - ... networking

Location:
The event-sponsor is Global Knowledge in Mechelen:
Zandvoorstraat 1
2800 Mechelen

A route description can be downloaded here.

Registration is needed and is open.

Registration will be closed on May 26

Microsoft will release SQL Server 2005 SP3 before the end of this calendar year: read more about it here.

We will have 2 sessions: 

Session 1: "linked servers" in Sql Server given by Michel Ulens

Abstract: 
MS SQL Server has been enjoying increasing popularity as a database platform. But of course, many organizations have other RDB platforms installed. Linked servers provide an elegant solution for organizations wanting to integrate MS SQL server apps with other (legacy) RDB platforms. We'll demonstrate how to accomplish this by linking to an Oracle database, and giving a clear example of how to extend the power and flexibility of your database needs.

Level: 200

Session 2: "SAP on Sql Server" given by Guy Germompre

Abstract:
Het gebruik van SQLserver onder SAP. Wat is SAP? Hoe maakt SAP gebruik van een database? Welke voordelen kunnen klanten hierbij halen? De verregaande integratie tussen SAP en Microsoft op vlak van database beheer.

Level: 200
Agenda:
18:00 - 18:30 Welcome with a drink
18:30 - 18:40 Intro
18:40 - 20:00 Session 1
20:00 - 20:30 Pause
20:30 - 21:30 Session 2
21:30 - 22:00 drink & sandwich

Location:
Delaware Consulting
Uitbreidingstraat 2 - 8
2600 Berchem 

A route description can be found here.

Registration is needed, registration is open.

Registration will be closed on March 24

Despite public confidence that SQL Server 2008 would ship by the end of June, Microsoft today indicated it probably is more likely to arrive toward the end of the year...

more here

Following my first article that explained this by using a cursor, there is also an undocumented stored procedure to execute the same operation against every table in a database.

Check out this script to disable all constraints and triggers with only 2 lines of code:

This could be interesting to truncate all tables are before you do a bulk insert.

Afterwards just enable them with another 2 lines of code:

Yep, that's it. Only 2 lines of code!

On January the 17th, Gunther Beersaerts of Microsoft was the guest speaker of the first SQL Server User Group Evening of this year.

Gunther gave us a very interesting overview of the new features of SQL Server 2008.

This evening was organized by Ordina and SQLUG.

It was a great evening with lots of usefull information, over 60 guests, and a nice drink afterwards. A perfect evening ;-)

You can download Gunther's presentation from SQLUG.BE or see some more pictures on Sven Cipido's Flickr Stream.

Technical Overview of the Next Release of Microsoft SQL Server : SQL Server 2008, codename "Katmai"

Abstract:
In this session we will provide an overview of the next release of SQL Server, SQL Server 2008, codenamed "Katmai". The session will cover the core value-proposition, major themes and scenarios, and the specific engine improvements, including the new Management Framework, datatypes (spatial,…), new Reporting Engine, FileStream, etc. We also cover the new development processes being used to build this release, the release timeline and the disclosure calendar.

Level: 200 – 300
Depending on the audience, we'll remain high-level (management / decision maker audience) or go more deeper (DBA, Developer or technical BI audience).
Speaker:
Gunther Beersaerts is a Senior Technical Specialist at Microsoft Belgium & Luxembourg.
Agenda:
18:00 - 18:30 Welcome
18:30 - 21:00 Session with pause
21:00 - 22:00 Drink
Registration is needed, you can register here.

Location and evening-sponsor:
Ordina
Boomsesteenweg 28
B-2627 Schelle
A route description to Ordina in Schelle can be found here.