Error while importing the data from one server to another

• notes4we

  SSCommitted

  Points: 1565

  More actions

  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

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

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  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