We are upgrading a 15 year old code-base, there is a requirement to create some native BCP formatted data files.
In the new system, we would ideally like to utilize data in a C# DataTable object to create the data file in native BCP format.
Can this be done and if so, what would be the best approach?
No, it can't be done, the only way we've discovered to create native BCP files is by using SQL Server. If anyone develops or finds another way please post it here!