Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL pipe-delimited text with header row RE: pipe-delimited text with header row

  • October 17, 2017 at 5:58 am

    #1963993

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