I saw another entry on this, however it went unanswered. I'll try again and maybe there is newer information/functionality now and hopefully it will help both of us.
I intended to use bcp as one component of an archival process. However, during a test to recreate or insert into a new table I do not see any switches or options to tell bcp to create the table if it doesn't exist. Since the formtat file
contains the column descriptors, I would have expected bcp to provide the create table functionality (rather than having to know the orignal table format and hardcoding the create table definition into the recover or reload process). An I overlooking
something? Is there some new functionality using XML format files that would do this?
bcp bulk insert create table invalid object name
View Complete Post