• Do you even need the table variable? Seems to me that you are creating the table variable strictly for the purpose of performing a relatively trivial update on the result set from the sproc master..xp_servicecontrol.

    I'd recommend using EXEC master..xp_servicecontrol as your data flow source query, and then update those three columns in a Derived Column transformation. This will eliminate the need for the table variable entirely.

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices