Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Import and Export Wizard

Answered Import and Export Wizard

  • Tuesday, March 19, 2013 8:24 PM
     
     
    Sign In to Vote
    0

    I am importing a table and its data from one database to another and getting the below error:

    Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80004005  Description: "Invalid date format".
    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80004005  Description: "Invalid date format".
    (SQL Server Import and Export Wizard)

    Let me know if anyone has a fix for this issue.

     

All Replies

  • Tuesday, March 19, 2013 8:49 PM
     
     
    Sign In to Vote
    1

    Are the databases on the same on the same server?

    By the looks of it they are on different servers and both the servers have differnt locale settings on them.

    What you can do is in your SSIS package use a DataConversion Trasnform to pass the data, or use a cast expression on the source query to convert the date fields to datetime 

    Abhinav
    http://bishtabhinav.wordpress.com/

     
  • Tuesday, March 19, 2013 9:05 PM
     
     
    Sign In to Vote
    1

    Hi,

    It seems the date column you are trying to load is not having correct format. Try to preview the data when you connect to source table.

    Thanks, hsbal

     
  • Tuesday, March 19, 2013 10:02 PM
     
     Answered
    Sign In to Vote
    0

    Thanks, I changed my destination datatype for all the date fields and it worked fine.

    Vijetha