Microsoft ODBC driver for Oracle ORA-00942: Table or view does not exist issue

I have a SQL 2005 job that runs some script to pull info from Oracle to SQL.   The script is unchanged and executes once daily in the AM, however started receiving the error message on 2/19/2015.  I just started with this company and am going through all the servers, DB's, etc...  

I have verified that the connection criteria is working.   The other possible issues I have found could be can't find the table or view, or possibly a schema definition in the script?  I have included the  error message below along with the the script from the first step (and error is occuring on first step.  

Message
Executed as user: DOMAIN\SERVER$. Error Code: 0  Error Source= DBServer.Retrieve  Error Description: [Microsoft][ODBC driver for Oracle][Oracle]ORA-00942: table or view does not exist    Error on Line 9.  The step failed.

VBScript:

Dim oCOM
Dim sSrcConn
Dim sDestConn

sSrcConn = "DRIVER={Microsoft ODBC For Oracle};SERVER=Alpha.Omega;UID=abcdefg;PWD=12345678"
sDestConn = "Provider=SQLOLEDB;Server=SERVER01;Database=Stat;UID=;Trusted_Connection=yes"
   
Set oCOM = CreateObject("StatEmp.Emp")

oCOM.LoadCatalogData sSrcConn, sDestConn
   
Set oCOM = Nothing
Set sSrcConn= Nothing
Set sDestConn= Nothing