How to export query result to PIPE delimited file

This short video shows how to use SSMS Export wizard to export query result to PIPE (|) delimited file.

[@davilima81]

Thanks for shared 👍

[@sqlservertutorialin3minute485]

You might have too large data to export. Maybe to export them in batch

[@suji6780]

Iam getting query time out, not able to parse..do we have any other option

[@abbasthegreat5]

What if we don't want to do it manually?

[@sqlservertutorialin3minute485]

You can set up SSIS DTS package to export.