Importing Data Using The Wizard: Mixing The Wrong Ingredients

by Valentino Vranken 3 May 2010 20:39
A while ago I wrote an article about how you can use the SQL Server Import and Export wizard to import Excel data into a SQL Server database.  In this sequel I’m going to show you some problems which you may encounter when using that wizard.  Just like any good old wizard, he’s only as [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (153) | Post RSSRSS comment feed

Importing Excel Data Using Integration Services

by Valentino Vranken 20 April 2010 21:21
In a previous article I’ve shown you how to import data from an Excel sheet using the OPENROWSET() function.  And I concluded by stating that it’s not the best option when automating your data import. Today I’ll repeat the Excel data import process by using SQL Server Integration Services, also known as SSIS. I’ll be using SQL [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (131) | Post RSSRSS comment feed

Retrieving Data From Excel

by Valentino Vranken 29 March 2010 20:16
The purpose of this article is to demonstrate how to retrieve data from an Excel sheet and put it in a table in a SQL Server database. Introduction Anyone who’s ever used a computer for a significant amount of time has probably come into contact with Excel, the spreadsheet application part of the Microsoft Office suite. Its [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (107) | Post RSSRSS comment feed

The Excel Auto Fill Feature

by Valentino Vranken 20 February 2010 21:29
A couple of days ago I discovered a very interesting double-click feature in Excel. One that probably already exists for ages – the oldest version that I was able to try it out on is Excel 2002 and it worked – but due to being used to other habits I just never found out about [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,

A Developer's Blog

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (188) | Post RSSRSS comment feed

SSAS: Custom format string for “duration” using MDX

by Davy Knuysen 7 December 2009 21:38
I recently struggled with the following challenge in Analysis Services: In one of the fact tables there was a field duration which actually was a duration of a certain status in seconds. I needed to display this in a readable format, like “2 days 22:15:59″. bing brought me to the following great article, where Mosha explains how [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , , , ,

Davy Knuysen

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (343) | Post RSSRSS comment feed

Excel Services: Data Refresh Failed

by Davy Knuysen 12 August 2009 22:41
After deploying an Excel file to Excel Services on a new MOSS Server I got the following error: Data Refresh Failed: Unable to retrieve external data for the following connections: <<connection>> The data sources may be unreachable, may not be responding, or may have denied you access. Verify that data refresh is enabled for the trusted file location [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , , ,

Davy Knuysen

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (401) | Post RSSRSS comment feed

OLAP Reporting with Excel 2007: Use Member Properties!!

by Davy Knuysen 3 August 2009 20:55
Excel 2007 is great tool for browsing OLAP cubes. But 1 thing a lot of people don’t know about or at least don’t use enough, is Member Properties. When they want to add a property of a specific attribute, they just check this item in the field list. By using it this way, you’re kind of [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , , , , ,

Davy Knuysen

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (285) | Post RSSRSS comment feed

Import Excel files with SQL Server Integration Services on a 64-bit server

by Davy Knuysen 26 August 2008 21:22
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: [...]
Click here to see the original post

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,

Davy Knuysen

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (409) | Post RSSRSS comment feed