====== Loading Excel files with SSIS ======

This SSIS package takes any '.xlsx' Excel file and loads it into a database table called ''dbo.WorksheetCell''.

<WRAP leftalign round download 40%>
{{ :ssis:loadexcelfile.dtsx |LoadExcelFile.dtsx}}
</WRAP>


===== dbo.WorksheetCell =====
<code tsql>CREATE TABLE dbo.WorksheetCell (
  LoadingProcessId INT NOT NULL 
, SpreadsheetCellId BIGINT IDENTITY NOT NULL
, WorksheetFilePath NVARCHAR(1024) NOT NULL
, SheetName NVARCHAR(255) NOT NULL
, CellAddress NVARCHAR(10) NOT NULL
, ColumnReference AS  LEFT(CellAddress, IIF(SUBSTRING(CellAddress, 2, 1) LIKE '[a-z]', 2, 1))
, RowNumber AS TRY_CAST(RIGHT(CellAddress, LEN(CellAddress) - IIF(SUBSTRING(CellAddress, 2, 1) LIKE '[a-z]', 2, 1)) AS INT)
, CellStringValue NVARCHAR(1024) NULL
)
</code>

{{tag> ssis excel}}