I have enabled logging using database.
When I try to query the sysdtslog90 table using System::ExecutionInstanceGUID to link executionid - it is not matching.
Any resolution?
Thanks
The variable System::ExecutionInstanceGUID always matches the sysdtslog90.executionid column when I try it.
Are the times matching up? Are you looking in the right table? Try using a Script Task to fire an event with the ExecutionInstanceGUID in the description text, so that it is logged and you can compare the two values in the same row.
|||It worked when I pass the System::ExecutionInstanceGUID as VARCHAR parameter instead of GUID in SQL Task parameter mapping. And when the stored procedure recieves the same parameter as uniqueidentifier
sorry for my late response.
Thanks
