Use ssis tool to extract data, in performing the service logic times wrong, check the error log information as follows, could you tell me how to and good methods to solve the great god

Execute the query "UPDATE ETL_PROGRESS_LOG
The SET ETL_END_TIME=to_cha... "Failure,
Error is as follows:
"ORA - 01403: not found any data
ORA - 06512: the "TEST. FN_ETL_PROGRESS_STAT,"
The line 45
ORA - 06512: the "TEST. TRIG_ETL_PROGRESS_LOG,"
Line 23
ORA - 04088: the trigger 'TEST. TRIG_ETL_PROGRESS_LOG' error in the implementation process, "
Failure reason may be: there is something wrong with the query itself, is not properly set "ResultSet" properties, or not properly connected parameter was not set correctly,

CodePudding user response:

Execution of the statement?

CodePudding user response:

Check seems to be the trigger, trigger, carry out your update statement in the database alone try error no, what's wrong

CodePudding user response:

Problem has been resolved, tools in a variable is not set to an error

CodePudding user response:

I also encountered this problem, please the original poster is how to solve? What need to set the inside in the tool?

CodePudding user response:

My is SQL export data to excel, error title: SQL Server import and export wizard
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Error 0 xc002f210: prepare the SQL task: to execute queries "CREATE TABLE ` tryagain $` (
` CB species number ` LongText,
` Lin ` LongText,
` static ` LongText,
New ` ` LongText,
In the spring of ` ` LongText,
` China ` LongText,
` cloud ` LongText,
` south ` LongText,
Your ` ` LongText,
` Yang ` LongText,
` F11 ` LongText
)
"Failure, mistakes are as follows:" 'tryagain $' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. ", the failure reason may be: there is something wrong with the query itself, is not properly set "ResultSet" attribute, or was not correctly connected parameter was not set correctly,


-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Button:

Sure
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --