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.  Read more...

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...

How can we determine the sheet names in our SSIS package and process this variable number of sheets?  Read more...

Longtime author Dinesh Asanka brings us a short tutorial on importing your data from Excel 2007 into a database using Integration Services.  Read more...

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...

Integration Services is a great ETL tool, allowing you to build complex and dynamic transformations. New author Marie Deschene brings us a  Read more...