I have a need to extract data to an Excel file as a scheduled job and FTP it to location.
SSIS seems the perfect tool to do this.
I am populating the output data from a simple 'Select * from MyTable' command.
The Excel file is populated but it does not include the column names from the table.
Is there a way of setting the first line of Excel to equal the column names from the select statement without them pre-existing in the Excel file destination?
Dazed and confused.
Remember.. 'Depression is just anger without enthusiasum'.
SSIS seems the perfect tool to do this.
I am populating the output data from a simple 'Select * from MyTable' command.
The Excel file is populated but it does not include the column names from the table.
Is there a way of setting the first line of Excel to equal the column names from the select statement without them pre-existing in the Excel file destination?
Dazed and confused.
Remember.. 'Depression is just anger without enthusiasum'.