Post reply

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"

  • December 11, 2014 at 1:53 am

    #295827

    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

  • December 11, 2014 at 2:00 am

    #1763978

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

  • December 11, 2014 at 2:16 am

    #1763984

    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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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