none
conversion issue - from SQL Server 2018 back to Microsoft Access 2007 RRS feed

  • Question

  • Hi technical supporter,

    What is the equivalent of Microsoft Access data type "memo" to SQL Server 2018 data type, and vice versa ?

    What is the equivalent of Microsoft Access data type "text" to SQL Server 2018 data type, and vice versa ?

    ==============================================================

    I was working with SSIS, and here is the error I am getting 

    [ADO NET Destination [2]] Error: An exception has occurred during data insertion, the message returned from the provider is: 
    Data type mismatch in criteria expression.

    [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component 
    "ADO NET Destination" (2) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (9). 
    The identified component returned an error from the ProcessInput method. The error is specific to the component,
    but the error is fatal and will cause the Data Flow task to stop running.  
    There may be error messages posted before this with more information about the failure.

    =============================================================

    Truly, 

    Patsy Farkas

    Monday, September 16, 2019 4:45 PM

All replies