Forum Discussion

pepper1976's avatar
pepper1976
Copper Contributor
Jan 12, 2024

Date Field In SQL Server

Hi i am Using a Third Party Tool to import Data into SQL Server, the Problem that i am having is one of the Fields i am importing via the Transform Tool is a data field which is blank in the Fox Pro Database, however when it is Imported into SQL server it reads as 0001-01-01, i have lots of views that rely on this table and a SSAS Cube which fails because of that data, is there any way i am able to change that data to a more relevant one say 1976-01-01

 

Thanks

 

 

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Agree, if you have an issue with a 3rd party application, then contact the software support.
  • LainRobertson's avatar
    LainRobertson
    Silver Contributor

    pepper1976 

     

    Hi, John.

     

    We can't help you with Fox Pro or your third party tool, in which case all we can suggest is running a post import update that sets the date to NULL (or '1976-01-01' as per your comment, though I don't understand where this comes from given you stated the original value in Fox Pro was blank) where it currently equals '0001-01-01'.

     

    Cheers,

    Lain

Resources