LoadFromSQLServer failed

• maffan76

  Ten Centuries

  Points: 1256

  More actions

  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

• jfb

  SSCrazy

  Points: 2469

  More actions

  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...

• maffan76

  Ten Centuries

  Points: 1256

  More actions

  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