Hi @MADDELA SATISH KUMAR REDDY ,
Please refer below:
<Extension Name="CSVTXT" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<OverrideNames>
<Name Language="en-US">TXT (Pipe Delimited Text File)</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FileExtension>TXT</FileExtension>
<NoHeader>true</NoHeader>
</DeviceInfo>
</Configuration>
</Extension>
or
<Extension Name="PIPE" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
<OverrideNames>
<Name Language="en-US">TXT (Pipe delimited)</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<FieldDelimiter>|</FieldDelimiter>
<FileExtension>txt</FileExtension>
</DeviceInfo>
</Configuration>
</Extension>
Don't forget to back up your config file and restart SSRS.
Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November