Hi,
I have a DTS all of the Task inside my DTS works fine except for one of them which is it not triggering. This task will trigger only after successful population of the table. My other task has the same precedence but it trigger successfully except of this specific task, that's why I need to run this task manually.
I checked the log file I cannot see any traces of errors
I already tried...
EVH316
Last Activity: Oct 19 '09, 12:27 AM
Joined: Aug 12 '08
Location:
-
DTS Task not running... wierd...
-
Scheduled DTS Problem
Hi,
I have a DTS (Data Transformation Serives) that was scheduled to run every morning. But it always got ang error message in its log file:
Step Error Source: Microsoft OLE DB Provider for ODBC Drivers
Step Error Description:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
But when I run my DTS manually, it runs succesfully. I checked my ODBC that... -
Thanks CK for the info but I still got the same error message... -
Hi CK,
Thanks for the reply this the actual message:
Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'OracleLinkedSe rver' does not contain table '"dwa"."dwa_tem p_div_stg"'. The table either does not exist or the current user does not have permissions on that table.
OLE DB error trace [Non-interface error: OLE DB provider does not contain the table: ProviderName='O racleLinkedServ er',...Leave a comment:
-
Hi CK,
Here's my exact query and I inclulde also how did I create my link server:
EXEC sp_addlinkedser ver @server = 'OracleLinkedSe rver', @srvproduct = 'Oracle', @provider = 'MSDAORA', @datasrc = 'KTPDEV';
EXEC sp_addlinkedsrv login 'OracleLinkedSe rver', FALSE, 'sa', 'dwa', 'dwa';
SELECT * from OracleLinkedSer ver..dwa.dwa_te mp_div_stg;
Thanks...Leave a comment:
-
Question using SP_ADDLINKEDSERVER
Hi To All,
I'm having problem when accessing my Oracle table in SQL Server, I successfully created and OracleLinkedSer ver but when I tried to select the oracle table via linked server I encountered the error message OLE DB provider 'OracleLinkedSe rver' does not contain table '"[oracle schema]"."[tablename]"' Actually the owner of the table is under the schema that I mentioned when creating my linked server.... -
Is DTS possible to schedule like a job process?
Hi,
Is DTS can automate like schedule job? How?
Thanks in advance -
Hi Stewart,
Thanks for your response....I'l l try your solution to my problem...Thank s again..
EVH316Leave a comment:
-
Hi Stewart,
Thanks for the response, here is the content of the query
...Code:SELECT dbo_SALFLDGDSN.ACCNT_CODE, dbo_SALFLDGDSN.PERIOD, dbo_SALFLDGDSN.JRNAL_NO, Sum(dbo_SALFLDGDSN.AMOUNT) AS SumOfAMOUNT, dbo_SALFLDGDSN.D_C FROM dbo_qrySSRFADDDSN INNER JOIN dbo_SALFLDGDSN ON dbo_qrySSRFADDDSN.ADD_CODE = dbo_SALFLDGDSN.ACCNT_CODE GROUP BY dbo_SALFLDGDSN.ACCNT_CODE,Leave a comment:
-
i agree with bedasisa, function index for "LOWER(V_CIName )" will solve your problemLeave a comment:
-
try execute this in DOS prompt
exp scott/tiger@SID file=backup.dmp tables=(table1, table2, table3) log=mybackup.lo gLeave a comment:
-
what if write your query in a sql script then execute it in SQL*Plus. Use DBMS_OUTPUT to display the results of your query. I hope this helpLeave a comment:
-
TNS Writter Failure
Hello Oracle DBA Guru,
Is there anybody here had encoutered TNS Writter Failure error? Can you share what is the cause and the solution as well. Thanks... -
I think better use WHILE..DO..LOOP with your need. In this manner you can manipulate how much increament do you want to have.Leave a comment:
-
still waiting who can give solution to my problemLeave a comment:
-
...help please...
can anybody give me the syntax or example how can I implement the OpenRecordSet() method using MS Access query?
i'm still having "Too few parameters. Expected 3 [3061]"Leave a comment:
-
hi,
if I use:
Set rstDAO = Currentdb.OpenR ecordset(strQry )
what I know, I need to use:
Set qryDef = currDB.QueryDef s("Sum_Amt_Cash ierDirect")
to pass parameter (acct_code-> parameter of my query and supplied them with "9ARTNC" value )
qryDef.Paramete rs("acct_code" ) = "9ARTNC"
how can I pass the...Leave a comment:
-
thanks Stewart....sorr y for double posting because I'm too desperate and nobody can help me....Leave a comment:
-
Thanks Adezzi....
Sorry StewartLeave a comment:
-
help...how can I pass parameter to Access Query using VB
When I call this function Access gives me error msg "Too few parameters. Expected 3. [3061]" on the Set rstDAO = qryDef.OpenReco rdset. Then I changed to
Set rstDAO = qryDef.OpenReco rdset(dbOpenSna pshot, dbOpenSnapshot, dbOpenForwardOn ly)
Now it gives me error "Invalid Arguments [3001]"...pls help...
here is my code:
...Code:Public Function GetTotalAmt(strAcct_Code As String) As Long
No activity results to display
Leave a comment: