Error while exporting SQL Server 2005

• Rick Allen

  Newbie

  Points: 3

  More actions

  September 29, 2007 at 11:45 pm

  #181691

  I am trying to export may db and this is the error I get;

  Execute the transfer with the TransferProvider. (Error)

  Messages

  ERROR : errorCode=-1071607780 description=There was an error with output column "MerchantID" (43) on output "OLE DB Source Output" (12). The column status returned was: "Conversion failed because the data value overflowed the specified type.".

  helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider)

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

  any ideas?... Thank you

• nigelrivett

  SSCertifiable

  Points: 5472

  More actions

  September 30, 2007 at 10:40 am

  #737538

  First thing to do is to check that the source database is ok.

  Try selecting the max value for that column and see if you get an error.

  Try dbcc checdatabase also.

  What are you trying to do - maybe there is an easier way.

  
  Cursors never.
  DTS - only when needed and never to control.