I have number of tables with NULL column values allowed within them.
I have data files which I need to import into these tables using BCP. As expected, BCP needs matching columns with text data and surely not the case here.
I can see suggestion of using format file but it's not working for me.
I don't want to hand edit tonnes of files.I need to know if there is an easy way to create format files using BCP switches or any other alternative?