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: 246961 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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

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: 246961 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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

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.