469,622 Members | 1,462 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,622 developers. It's quick & easy.

Destination Columns Question

When I create a DTS to export a text file from a table, if I click on
the Define Columns button and then Populate from source, then execute,
it changes one of the types to not quotable and the size to 19, which
in turn is changing the file width. The field that it is changing has
a numeric data type and the remainder of the fields are text (all
varying sizes). Is it doing this because it is numeric or is there
some other explaination? And is there anyway to stop it from
happening?

Jul 23 '05 #1
1 1583

"Krissy" <kh*********@peoplepc.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
When I create a DTS to export a text file from a table, if I click on
the Define Columns button and then Populate from source, then execute,
it changes one of the types to not quotable and the size to 19, which
in turn is changing the file width. The field that it is changing has
a numeric data type and the remainder of the fields are text (all
varying sizes). Is it doing this because it is numeric or is there
some other explaination? And is there anyway to stop it from
happening?


If the data type is numeric with no precision and scale, then by default it
will be numeric(18,0). That means the maximum length of a value would be 18
digits, plus one character for a sign, giving 19, so making the output
column 19 characters wide means that all possible data values will fit. If
you create another column as numeric(10,5) or whatever, then you'll see that
DTS gives it a different size (12 in the case of numeric(10,5) - 10 digits,
1 decimal point, 1 sign). See "decimal and numeric" in Books Online for more
details.

I'm not sure why you want to stop this happening - perhaps if you can
explain why this behaviour is a problem, someone may be able to suggest a
workaround.

Simon
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

40 posts views Thread by Mark | last post: by
13 posts views Thread by Dave White | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.