SQL Server Performance

DB2 to SQL DTS problem

Discussion in 'SQL Server DTS-Related Questions' started by misterno, Feb 5, 2004.

  1. misterno New Member

    hi, there
    I have a DTS that transfers data from DB2 to SQL.
    the problem is that it works when the total data to trasfer is below 1M bytes
    otherwhise it trunkates data.

    does anyone know if there is a transfer limit?
  2. Luis Martin Moderator

    There is no transfer limit from SQL point of view.
    May be the problem is from DB".


    Luis Martin
    Moderator
    SQL-Server-Performance.com
  3. misterno New Member

    thanks, I'll check DB2

Share This Page