Loading Excel files with SSIS

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

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
)