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: 246695 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'.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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: 246695 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).

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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.