September 1, 2009 at 6:28 am
Probably a stupid question but I just cannot find where to do it. What I am doing is using an OLE DB source which returns data from a stored procedure and sending this to a csv destination file. What I would like is to populate the first row in the destination file with the field names from the OLE DB query.
Any help would be greatly appreciated.
September 1, 2009 at 6:59 am
Check the box "Column names in the first data row" in your flat file connection manager editor's General tab.
September 1, 2009 at 7:10 am
It sounds like you are trying to create the output file meta data (ie, the column names and data types) dynamically, is that correct?
This isn't really how SSIS works - it needs the meta data configured as part of your connection object.
Your best bet is to create a text file which is empty except for the field headings:
Name,Address1,State,F1,F2,FN
and then map your data to that.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
September 1, 2009 at 7:44 am
You're bang on. Thanks, I added the field names to a template file and it works perfect now. Thanks very much.
September 1, 2009 at 9:07 am
Great, thanks for posting back.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply