srionline2k6
asked on
Audit logging usign SSIS using Execute sql task... Need help
I have to log the result in the audit table in ORacle as I am not aware much of oracle I think I am doing something wrong here. Below is the table that I need to populate into and I have this values. How do i need to populate using SSIS execute sql task. I did mapped the variables in the parameter mapping in executesql task I
insert into audit_logs
(file_type,importing_Host, source,Dir ectory, filename,LOAD_DATE,LOAD_ST ATUS,LOADE D,ERRORS,D ISCARDED)
VALUES([User::FileType],
[System::MachineName],"Inc ognito_ser ver",[User ::SourceDi rectory]," Incognito" ,SYSDATE," SUCCESS",[ User::Inse rtRowCount ],NULL,NUL L)
I put them in Execute sql task and ran along with teh dataflow task while dataflow task is successful when it comes to this query. I faced the following error...
Do i need to pass in the expressions tab as a sqlstatementsource.
[Execute SQL Task] Error: Executing the query "
insert into audit_logs
(file_type,
Imp..." failed with the following error: "ORA-01036: illegal variable name/number". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Am i doing anything wrong? Please guide me through this
insert into audit_logs
(file_type,importing_Host,
VALUES([User::FileType],
[System::MachineName],"Inc
I put them in Execute sql task and ran along with teh dataflow task while dataflow task is successful when it comes to this query. I faced the following error...
Do i need to pass in the expressions tab as a sqlstatementsource.
[Execute SQL Task] Error: Executing the query "
insert into audit_logs
(file_type,
Imp..." failed with the following error: "ORA-01036: illegal variable name/number". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Am i doing anything wrong? Please guide me through this
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://technet.microsoft.com/en-us/library/ms140355.aspx