Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS 2008 To Excel Including Column Names

Status
Not open for further replies.

Skittle

ISP
Sep 10, 2002
1,528
US
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'.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top