In SQL Server 2012 Imports (using SQL Server Import And Export Wizard) from web server where a datatype - "datetime" but in local sql 2012 server change datatype to "smalldatetime"

  • how to solve

    In SQL Server 2012 Imports (using SQL Server Import And Export Wizard) from web server where a datatype - "datetime" but in local sql 2012 server change datatype to "smalldatetime"

    Dinesh

  • save it as a SSIS package and use data conversion transformation to convert it to relevant datatype.

  • sunder.bugatha (12/11/2014)


    save it as a SSIS package and use data conversion transformation to convert it to relevant datatype.

    Any data that has already been lost during the conversion to SmallDateTime will not magically reappear if converted back to DateTime.

    Better to change the datatype of the source columns.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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