I'm trying to import a file into DB that a user would drop into a folder from BOXI. At this point the Excel file has the top row missing, due to the set up in BOXI, and when I map in SSIS the column names are F1, F2 etc.
Obviously I want the first row to be the column names.
I've set up a variable for the filename, but first need to set the expression of the variable to set the column definitions, but not sure of the actual text of expression script. In this exppression I want to ignore the first row and define the next row as the header.
Do I just use the actual names of the columns in the sheet and cast them as varchar(X) i.e.
select CAST(Name AS VARCHAR(100)) AS Name, CAST(Address AS VARCHAR(200)) AS Address, ....,......,....,..., from 'Name (Alpha)$A2:F'
Note: Sheet name is default 'Name (Alpha)$' never heard of that but that's what it exports as.