Post reply

Error while importing the data from one server to another

  • October 17, 2008 at 7:20 am

    #214138

    TITLE: Microsoft.SqlServer.DtsTransferProvider

    ------------------------------

    ERROR : errorCode=-1071636471 description=An OLE DB error has occurred. Error code: 0x80004005.

    An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification".

    helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

  • November 14, 2008 at 1:32 am

    #898442

    Are you using a Data Conversion task? It seems as if you're trying to cast character data to a numeric data type, and there illegal values in the source.

    ML

    ---
    Matija Lah, SQL Server MVP
    http://milambda.blogspot.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply