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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Exporting bit data type using DTS

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2005-07-06 : 09:23:17
When i export a table having bit column to a text files using DTS, i get the resultant bit values as YES or NO, instead of 0 or 1.

How to get the required result?

(We can do this using a convert function in a query, and DTS. Is there a better way?)



------------------------
I think, therefore I am - Rene Descartes
   

- Advertisement -