Re: Numbers are interpreted as varchar columns by the text file connection
From: the guy (guyemup_at_yahoo.com)
Date: 10/04/04
- Next message: Karthik R: "BulkInsert: Record Count"
- Previous message: jim_linder_at_newsgroup.nospam: "DTS error copying tables"
- In reply to: Karen Middleton: "Numbers are interpreted as varchar columns by the text file connection"
- Messages sorted by: [ date ] [ thread ]
Date: 4 Oct 2004 09:30:13 -0700
if i'm understanding your question correctly, i think your best bet is
to just manually change the column definition from varchar(255) to
float, int, etc. in the create destination table sql statement before
hitting 'ok'. i'm assuming you know which columns should be varchar
vs numeric.
karenmiddleol@yahoo.com (Karen Middleton) wrote in message news:<a5fd468a.0410020454.7b796251@posting.google.com>...
> I am using a Text File (source) connection and the input is a CSV file
> and the first row of the file as column headers. When I try to create
> a destination table DTS interprets columns which are numbers as a
> varchar (255) column but when I save the same .csv file from Excel as
> a .xls file and use a .XLS file as the connection with column headers
> DTS interprets them correctly as a float or double column.
>
> But I cannot afford to import these files into Excel and save them as
> .XLS file.
>
> Please can any of you suggest a workaround how I can overcome this
> problem and still get natural interpretation of a number as float or
> double without having to import the .csv file into Excel and save it
> as .XLS file.
>
> Thanks
> Karen
- Next message: Karthik R: "BulkInsert: Record Count"
- Previous message: jim_linder_at_newsgroup.nospam: "DTS error copying tables"
- In reply to: Karen Middleton: "Numbers are interpreted as varchar columns by the text file connection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
