Post reply

Instance Execution Guids are different for same run

  • September 29, 2009 at 1:48 pm

    #142260

    I am using the ExecutionInstanceGuid system variable in numerous places for auditing reasons. When I reviewed some of the logs I found that the same run of the ETL had different instance guids.

    I am using exectue sql tasks with parameters. In the parameters I set the data type to GUID. I went back and changed the type to string, then the guids matched.

    I'm I correct in assuming that when I set the type to GUID that I will get a NEW guid?

  • October 2, 2009 at 6:18 am

    #1060852

    The ExecutionInstanceGuid system variable should be mapped as a string. It's unintuitive but if you map it to your parameter as a GUID it gets translated into another value entirely.

    Kindest Regards,

    Frank Bazan

  • October 5, 2009 at 6:16 am

    #1061658

    Frank,

    I did map all my guids to strings. Thanks for the confirmation.

    Like you said unintuitive.

    Thanks - Tom

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply