Post reply

Importing data from one table to another table

  • September 16, 2009 at 12:19 am

    #141741

    Hi,

    I am trying to import data from one table to another where source columns are nvarchar and destination columns are like datetime,int,bigint

    while importing i get error saying

    Arithmetic overflow error converting expression to data type datetime.

    How can import all the data from one to another

    Thanks for the help

  • September 16, 2009 at 4:19 am

    #1054322

    What format is the date that's stored as an nvarchar? Only certain date styles are implicitly convertable from nvarchar to datetime.

    How are you importing? (e.g. the Import/Export Wizard/SSIS?)

    I'd suggest that instead of trying to do a straight table-table import, you write a select statement on the source table that manipulates the data and casts as the appropriate data types for the destination table first, then use this query to import the data.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply