Link to home
Start Free TrialLog in
Avatar of srionline2k6
srionline2k6Flag for United States of America

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,Directory, filename,LOAD_DATE,LOAD_STATUS,LOADED,ERRORS,DISCARDED)

VALUES([User::FileType],
 [System::MachineName],"Incognito_server",[User::SourceDirectory],"Incognito",SYSDATE,"SUCCESS",[User::InsertRowCount],NULL,NULL)
 


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
Avatar of BartVx
BartVx
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The above is correct for OLEDB and Excel connections. For you specific connection, check following link:

http://technet.microsoft.com/en-us/library/ms140355.aspx