ETL and Data Integration tools - Modern ETL software for everyone

Hello

I am a user of Visual Importer Enterprise Version: 7.7.5.14 and I hope you can help.

How can I export from a sql table to a text file with | (pipe) as the delimiter and NULL as nothing (eg || (pipe pipe) not |NULL| (pipeNULLpipe)). I will want to do this for multiple tables and so I don't want to set up the format for each column. I can't do IsNull within sql because they are views and end up coming out with odd results.

At the moment I use sql batch exporter BCP to export to a text file delimited with pipe |

But if I use my case all attempts to import this it always falls over at a line with a NULL

Scott

This was added to Visual Importer Enterprise a while ago

Just create new export object or use export wizard
Tools => data export wizard

Mike