var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Converting text to table with DTS
I am using DTS to import text to a table. This mostly works except for the 'DateTime' datatype where I always run into either 'Arithmetic overflow' or 'Unable to convert varchar to DateTime format.' I can convert same data without incident in Access.
Has anyone run into this problem?
Import the problem dates into a VARCHAR(30) column using DTS. Then mangle them at will using the SQL functions to make them easier to digest!
I'm kind of new to SQL...do you mean using functions like CAST and CONVERT in custom DTS packages?
whats the format of date in the text file? use IsDate() function in the transformation ActiveX to check for validity of date
Import everything in to an existing tables as varchar...the perform your audits...
Originally Posted by
and learn bcp.......
Is the file fixed width or delimited?