473,327 Members | 1,997 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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 1657

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Bennett Haselton | last post by:
I'm working on an ASP.Net project where I want to test code on a local machine using a local database as a back-end, and then export it to the production machine where it uses the hosting...
8
by: pmud | last post by:
Hi, I have 2 questions: 1. I have an editable data grid with 21 columns. I need to edit only 2 cloumns in this data grid. But when the grid is displayed in Edit mode, all the columns show long...
40
by: Mark | last post by:
Hello i like to make the following lay out: - 3 columns - center column = fixed width - left and right columns are not fixed and must take all the available space there is left. - left...
1
by: tommalia | last post by:
I'm trying to write an XSLT to convert an XML document from one schema to another. The destination XML schema has an optional State element. The element can be left out, but if it's present...
17
by: vish | last post by:
Hi all, I know this might look strange at first look, but i am looping thru a dataset created using to different tables from database.These two tables have some fields with the same names. ...
13
by: Dave White | last post by:
Hello everyone, Is there some way to highlight the destination of a link such as a definition tag: <dt><a name="Definition">Definition</a></dt> Thanks in advance, Dave White
1
by: andymcintosh85 | last post by:
Hi all, I have a split database which i designed on my work computer, i have copied the database onto my home computer. When i try to open the front end i get the error message that the...
9
by: Earl | last post by:
I have somewhat of an interesting scenario: The form allows the user to select a service, which populates a a grid of product information related to that service ("service grid"). The user can...
1
by: Thi | last post by:
Hi, I am trying to develop an application that allows the users to drag a few file(s) from a zip archive to a destination. My question is, how do i determine where the drop destination is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.