VARCHAR, DATETIME2, BIGINT and INT do not exist as Excel Destination data types.
See the documentation -
Excel Destination[
^]
Try
CREATE TABLE componentReport(
WorkNumber NVARCHAR(20),
UnitDateEnd DATETIME(3),
UnitDateCreated DATETIME(3),
UnitId LONG,
Track INTEGER,
SupplierName NVARCHAR(50),
Stage INTEGER
)
Alternatively try exporting to a CSV or XML rather than an Excel Binary - from memory the Excel drivers were a bit flaky