Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
N-IGMA
Starting Member
7 Posts |
 Posted - 2005-06-16 : 05:27:45
|
| Hi,I have a table with columns set as BIT data type, when I query this table I get BITS returned (as you would expect!) however, when I export using the DTS wizard, all my BIT columns are changed to INTEGER(5) with no option under the column mapping for a BIT. I have tried to edit the SQL manually but to no avail, my .csv file has TRUE/FALSE in all the BIT columns instaed of 1/0!Has SQL Server lost the plot!?! Can someone please show me how to get round this very strange problem.TIAPhil Ewington.P.S - I am using SQL Server 2000 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-16 : 07:57:13
|
| Instead of exporting the table directly, use a query, and use cast(bitColumn as tinyint) for the bit columns you want to export.FWIW the bit datatype is supposed to represent boolean true/false, and most ODBC/OLE DB providers map it as such. |
 |
|
|
|
|
|
Cannot export BITS