• Now....

    For the SSIS bit.

    1) Create connectionmanager to your data

    2) Create a preparation SQL task which basically deletes the data, as per the delete statement

    3) Create a dataflow. OLEDB source to OLEDB destination. Use the select statement as your OLEDB source. Use Inquiryheader as your destination.

    4) Map source to destination

    TADA

    ~PD