Home Forums SQL Server 2005 Business Intelligence How to assign user variable a GUID value in Execute SQL Task using SSIS 2008 RE: How to assign user variable a GUID value in Execute SQL Task using SSIS 2008

  • July 28, 2011 at 9:54 am

    #1360265

    patelmia (7/28/2011)

    Hi opc.three,

    Thanks for your reply. Do you have any sample peice of code which shows how to use object inorder to acheive this task.

    my taks is I will get 10 guid's from select query need to loop through each guid and do some updates on other table with guid value.

    I could provide a sample SSIS pkg, but before I do, now that we have tracked down the problem this far, why are you doing this in T-SQL?

    Is your "other table" in the same database where you are getting the GUID from in the first place? If so, then why use SSIS? A simple set of T-SQL queries, possibly even one query, may get the job done for you. Can you share a little more about what you're doing?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato