DTS bit fields change to False/True

#1

I'm running a basic DTS of a view, exporting to CSV
format. I have several fields that are bit (1) which
convert themselves to False/True instead of remaining 0/1.

How can I keep the field bit(1) and display the 0/1
instead of text?

#2

In message <494e01c3e439$6d1de390$a401280a (AT) phx (DOT) gbl>, amber
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

I'm running a basic DTS of a view, exporting to CSV
format. I have several fields that are bit (1) which
convert themselves to False/True instead of remaining 0/1.

How can I keep the field bit(1) and display the 0/1
instead of text?

You could use a Source SQL Query and cast them to an integer type, e.g.

SELECT CAST(BitField AS tinyint) AS BitField, OtherFields...
FROM dbo.MyTable

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS bit fields change to False/True

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS bit fields change to False/True - 01-26-2004 , 12:22 PM

Re: DTS bit fields change to False/True - 01-26-2004 , 02:30 PM