Extracting Data From Excel with SSIS

Working with SSIS packages deployment. Ran into Excel connections problems.

Marius' SQL Server BI Blog

If seen quite a lot of questions on forums around extracting data from Excel workbooks using SSIS.  I therefore decided to write this post to demonstrate how to extract data from and excel workbook. When extracting data from Excel, driver errors are frequently encountered that relate to 32-bit vs 64-bit drivers, e.g.:

Error at Extract data from Excel [Connection manager “Excel Connection Manager”]: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode.

This article will explain what causes these error messages and how to get around them.

Prerequisites:

  • SSIS 2012 (although the process is very similar in 2008)
  • Microsoft.ACE.OLEDB.12.0 provider (both 32 and 64-bit)
  • An Excel 2010 or 2013 file with data on two sheets.

Steps:

  1. Create a new SSIS project and package.
  2. Right click in the Connection Managers tab and select New Connection…
    SSIS Extracting data from Excel 1
  3. On the Add…

View original post 517 more words

Spain: Lleida’s 14th-century Jewish community

How this relates to me?

Tracing the Tribe - The Jewish Genealogy Blog

Does the city Lleida or Lerida, in Catalunya ring a bell for Sephardic researchers?

There were two Jewish neighborhoods in the town – Cuirassa and Cuirassola – some 140km northwest of Barcelona.

The Lleida community was virtually destroyed in the 1391 riots, massacres and mass forced conversions; an attempt to reconstitute it years later never got very far.

There were Jewish communities in nearby villages as well – such as Alfés – which has numerous buildings with six-pointed symbols – una estrella de 6 puntes – above their entrance doors (see photos at left and below right). Some scholars and historians believe that these symbols were substituted for the six-pointed magen david.

In Converso communities elsewhere in the world – such as in New Mexico (according to Dr. Stanley Hordes and other historians), similar images are carved on gravestones.

Lleida’s archives, housed in the Cathedral, are a treasure trove…

View original post 184 more words