Post reply

LoadFromSQLServer failed

  • January 15, 2003 at 6:23 am

    #159251

    HI All,

    Few days back i created a package whihc exports data to Oracle, it was running fine from Query Analyzer and DTSRUNUI fine. Suddenly it has stopped working form Query Analyzer while it working from DTSRUNUI.

    when i try to run the package from Query Analyzer it give me an error pasted below.

    "LoadFromSQLServer failed

    OLE Automation Error Information

    HRESULT: 0x80040e14

    sp_OAGetErrorInfo failed."

    now i am in a fix and neew very urgent help, please help me.

    thanks in advance

    Kind Regards,

    Affan

  • January 16, 2003 at 10:40 am

    #446537

    What sp do you have on the sql box?

    Did you try to reinstall you oracle driver?

    Did you check the name of the pkg in the DTSrun line code? make sure is the right name.

    Johnny...

  • January 16, 2003 at 10:29 pm

    #446602

    Thanks Johnny,

    the package name was wrong as the font was very small and i could not catch the spelling mistake 🙂

    Kind Regards,

    Affan

Viewing 3 posts - 1 through 2 (of 2 total)

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