Post reply

DTS error

  • April 9, 2003 at 4:09 pm

    #151816

    Hi all. I'm getting an error in my DTS package, here it goes:

    "The number of failing rows exceeds the maximum specified. (Microsoft JET Database Engine (80004005): Cannot expand named range.)"

    Please help

  • April 10, 2003 at 3:52 am

    #453681

    Sounds like you are importing an Access database in your package. Make sure the table being inserted into can accomidate the data that is coming from the Access DB. If any columns width is too small or not null specified and a null value is coming in then you will have issues.

  • April 10, 2003 at 4:50 pm

    #453808

    there is no Access involved, from SQL 2000 strasight to Excell. I dropped the excell files and re-ran the package, and it worked.

    I'm still puzzled though. Oh well.

    Thanks for your reply

  • April 11, 2003 at 1:32 pm

    #453936

    Excel probably has an upper limit of 64K rows and your result probably exceeds that limit. I have seen this error while pasting a huge result in to Excel.

    Thanks

  • April 11, 2003 at 1:41 pm

    #453937

    nope, that wasn't it either.

    still searching though

  • April 11, 2003 at 3:28 pm

    #453955

    Hi,

    looks like permission error

    Or

    are you using text columns data type somewhere?

    JFB

Viewing 6 posts - 1 through 5 (of 5 total)

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