export my sql server database to msaccess - Validating (Error)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kkshansid
    New Member
    • Oct 2008
    • 232

    export my sql server database to msaccess - Validating (Error)

    i cannot export my sql server database to msaccess database which i usually did successfully 3weeks ago pls help me to find the error
    so that i can correct it in future

    error is

    - Validating (Error)
    Messages
    * Error 0xc02020f6: Data Flow Task: Column "Project ID" cannot convert between unicode and non-unicode string data
    types.
    (SQL Server Import and Export Wizard)

    * Error 0xc02020f6: Data Flow Task: Column "Title of the Project" cannot convert between unicode and non-unicode
    string data types.
    (SQL Server Import and Export Wizard)


    * Error 0xc004706b: Data Flow Task: "component "Destinatio n - std project" (79)" failed validation and returned
    validation status "VS_ISBROKE N".
    (SQL Server Import and Export Wizard)

    * Error 0xc004700c: Data Flow Task: One or more component failed validation.
    (SQL Server Import and Export Wizard)

    * Error 0xc0024107: Data Flow Task: There were errors during task validation.
    (SQL Server Import and Export Wizard)
Working...