pipe-delimited text with header row

Question

pipe-delimited text with header row

adisql

SSCrazy

Points: 2893
More actions
October 16, 2017 at 7:12 pm

#339901

Hi,
I need to save the result with pipe-delimited text with header row.
any suggestions please.
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246993 More actions · Answer 1

adisql - Monday, October 16, 2017 7:12 PM
Hi,
I need to save the result with pipe-delimited text with header row.
any suggestions please.
Thanks

SSIS can do this, depending on what you mean by 'the result'.

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

adisql SSCrazy Points: 2893 More actions · Answer 2

if i execute the select statement by a automate job then the result should be pipe-delimited text with header row.
for example the job executes a select statement [select name,address from table] then the result should be pipe-delimited text with header row in a output file(text file).

Phil Parkin SSC Guru Points: 246993 More actions · Answer 3

adisql - Monday, October 16, 2017 9:38 PM
if i execute the select statement by a automate job then the result should be pipe-delimited text with header row.
for example the job executes a select statement [select name,address from table] then the result should be pipe-delimited text with header row in a output file(text file).

This no problem in SSIS ... a basic package.
You'll need a data flow with an OLEDB source (which executes your query & collects the results) and a flat file destination (whose format you will define as you create the package).

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

adisql SSCrazy Points: 2893 More actions · Answer 4

Phil Parkin - Tuesday, October 17, 2017 5:58 AM
adisql - Monday, October 16, 2017 9:38 PM
if i execute the select statement by a automate job then the result should be pipe-delimited text with header row.
for example the job executes a select statement [select name,address from table] then the result should be pipe-delimited text with header row in a output file(text file).
This no problem in SSIS ... a basic package.
You'll need a data flow with an OLEDB source (which executes your query & collects the results) and a flat file destination (whose format you will define as you create the package).

Thank you.