Recently I needed to find a method to import one cell of an Excel sheet into SQL Server 2005 using a scheduled job on a 64 bit clustered environment. For example, I have a monthly sales report listing sales per product category, such as Books, Magazines, DVDs, etc. I only want to import the Total Sales amount into SQL Server and this number is located in an Excel file "sales.xls.sheet1.cell.B5". I used to use OPENROWSET to solve the problem, however OPENROWSET requires Microsoft Jet OLE DB Provider which is not available in 64 bit. In this tip I am going to talk about how to use SSIS to accomplish this task easily.

Safety in Numbers

by Steve Jones

SQLServerCentral.com

Editorial

One of the core things a DBA must do is ensure backup and recovery of data. This Friday Steve Jones asks about your tolerance for safety and backup data in a Friday poll.

Tips for New DBAs

by Craig Outcalt

SQLServerCentral.com

Career Growth

New and old DBAs alike can benefit from going back to the roots of the profession. This series of articles highlight the skills needed to move to the next level of Database Administration.

Azure Tutorial - Building a'Hello Word' app in Visual Studio

by Additional Articles

SQL Server Performance

Azure

This article demonstrates how to build a simple Azure app using Visual Studio

SSIS Alpha Splits using the CODEPOINT() Function

by Tim Mitchell

SQLServerCentral.com

Blogs

A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...

Covering Index using Included Columns

by Josef Richberg

SQLServerCentral.com

included columns

This article from Josef Richberg details the benefits of included columns for use in creating a covering index to improve performance.

Configure Windows Firewall to Work with SQL Server

by Additional Articles

MSSQLTips.com

Configuration

Windows Firewall is an OS level software firewall. It can be a crucial part of OS level security if you are not using other firewall hardware or software. Since I do not have another firewall I have a need to enable Windows Firewall for my SQL Server database server. In this article I go through the process of configuring Windows Firewall for different scenarios along with the associated considerations.

Key Discovery III

by Jason Brimhall

SQLServerCentral.com

Blogs

In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes. In...

Newsletter Changes for Yahoo Mail

by Press Release

SQLServerCentral.com

SQL Server Central

We have recently made a few changes in our newsletter sending process and been working with Yahoo to ensure delivery. If you are just receiving this newsletter to a Yahoo account, welcome.

The Best Laptop

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones recently went on a search for a new laptop, looking for the "best" one for him. But what it the best? And is it worth pursuing?

Use SSIS to import one cell of an Excel file into SQL Server

Safety in Numbers

Tips for New DBAs

Azure Tutorial - Building a'Hello Word' app in Visual Studio

SSIS Alpha Splits using the CODEPOINT() Function

Covering Index using Included Columns

Configure Windows Firewall to Work with SQL Server

Key Discovery III

Newsletter Changes for Yahoo Mail

The Best Laptop

Blogs

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

A Cloud Dependency Failure from Amazon

Deploying AI in logistics (the unfiltered version)

Forums

BCA KCP Kas Pagar Dewa TLP/WA 08216977749

BCA KCP Tebet Timur Telpon/wa:0813.7887.595

BCA KCP Pasar Minggu Center Telpn:0821•3111•185

Question of the Day

Creating a JSON Document III