Automate

 View Only

  • 1.  Date data type downloading to SQL Server

    Posted 21 days ago

    I am downloading EKKO directly to a SQL Server table with Created On and Document Date. I am getting this error:

    the SQL table is a basic import to table;

    the Winshuttle preview shows the dates 

    when I look at my SQL import table the dates look like:

    any insight on what I need to change?

    Jane



    ------------------------------
    Jane Dobbs
    Specialist Supply Chain
    Canadian Pacific Railway
    Calgary AB
    ------------------------------


  • 2.  RE: Date data type downloading to SQL Server

    Posted 20 days ago
    Edited by Jane Dobbs 19 days ago

    Now have an issue with the (EKBE) "Time of Entry"  I have it set to time(7) in SQL

    I have tried DateTime, TimeStamp and nothing works, get this error.


    the first issues were resolved by:

    The SQL Date column datatype has to be set to DateTime. 



    ------------------------------
    Jane Dobbs
    Specialist Supply Chain
    Canadian Pacific Railway
    Calgary AB
    ------------------------------

    Original Message