Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2003
    Posts
    68

    Unanswered: DTS Import Slow from As/400

    I'm using DTS to import data into SQL. Client Access ODBC is the driver I'm using. Any reason why DTS would move so slow pulling data down.
    I can run that same import from a local access database and it will
    run three times faster.
    thx
    jm
    jm

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's the data in on the AS/400?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Aug 2003
    Posts
    68
    JDE.. But the file isn't vanilla JDE.. Actually, I just create a File using query first, then I use DTS to import/translate..
    jm

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Can't you dump the data on the 400 then just copy and load it?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Mar 2004
    Posts
    14

    Re: DTS Import Slow from As/400

    Originally posted by jmayo
    I'm using DTS to import data into SQL. Client Access ODBC is the driver I'm using. Any reason why DTS would move so slow pulling data down.
    I can run that same import from a local access database and it will
    run three times faster.
    thx
    jm
    COULD BE YOUR NETWORK SERVICES, CHECK OUT HOW FAST IS WORKING YOUR NETWORK, IF YOU ARE WORKING ON WINDOWS, CHECK OUT TERMINAL SERVICES

  6. #6
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    are there any tranformations?
    how is your package transforming the data?
    are you using activex operations to perform the x-foms?

    activex is single threaded in dts that could slow down operations

    what is happpening on the SQL Side once you import the data
    are those tables indexed and do they have enabled constraints on them?

    constraint checking can slow down an import
    so can an index load.
    Disable your constraints and indexes before you perfom a bulk load

  7. #7
    Join Date
    Aug 2003
    Posts
    68
    Thanks for all the suggestions..
    I will look into each of them..
    To answer one of the questions, yes I'm using terminal services..
    thx
    jm
    jm

  8. #8
    Join Date
    Jul 2002
    Posts
    4

    Re: DTS Import Slow from As/400

    Originally posted by jmayo
    I'm using DTS to import data into SQL. Client Access ODBC is the driver I'm using. Any reason why DTS would move so slow pulling data down.
    I can run that same import from a local access database and it will
    run three times faster.
    thx
    jm
    We pull data out of the AS/400 here and there are two areas which will be the cause of performance problems.

    1)The speed of the network connection.

    2)the size of the tables you are transforming.

    Not much you can do apart from increase your network bandwith and the cards on the SQL Server and the AS/400 (I think we have Gigabit Ethernet cards on each end)

    For every thousand rows is takes approx three seconds - so if you are around this then you're doing OK.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •