October 16, 2017 at 7:12 pm
Hi,
I need to save the result with pipe-delimited text with header row.
any suggestions please.
Thanks
October 16, 2017 at 7:46 pm
adisql - Monday, October 16, 2017 7:12 PMHi,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.
October 16, 2017 at 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).
October 17, 2017 at 5:58 am
adisql - Monday, October 16, 2017 9:38 PMif 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.
October 17, 2017 at 10:53 am
Phil Parkin - Tuesday, October 17, 2017 5:58 AMadisql - Monday, October 16, 2017 9:38 PMif 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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply