Hi Gang:

I've inherited a database that contains a number of tables with bit value
columns. I am trying to write a script with bulk insert statements to
reconstruct the database. When I export the table data, the bit fields get
converted to string equivalents (True and False.) When the bulk insert
statement for the same table executes, I get errors saying that these values
can't be converted to bits.

Can you tell me how to export the data from my tables into text files so
that the bit values can be re-imported / bulk inserted correctly?

Why not use the native mode of BCP instead? That is the cleanest and
fastest way to export out and back into SQL Server tables. Check out BCP or
Bulk Insert in BooksOnLine for more details.

--
Andrew J. Kelly SQL MVP


"Robert Burdick [eMVP]" <RobertBurdickeMVP (AT) discussions (DOT) microsoft.com> wrote
in message news:F79A3F00-23EC-4027-884C-0C38696DCB15 (AT) microsoft (DOT) com...