您可以使用脚本组件来实现:

1. 添加脚本组件
2. 转到输入和输出"标签
3. 添加3个输出列:ID，出生日期，角色
4. 将SynchronousInput属性设置为None

1. Add a script component
2. Go to the Inputs and Outputs tab
3. Add 3 Output columns : ID, BirthDate, Role
4. Set the SynchronousInput property to None

1. 在脚本编辑器中，编写类似的脚本:

string ID = "";
string BirthDate = "";
string Role = "";
public override void Input0_ProcessInputRow(Input0Buffer Row)
{
   if(!Row.Attribute_IsNull && !String.IsNullOrWhiteSpace(Row.Attribute))
    {

        switch (Row.Attribute)
        {

            case "ID":
                ID = Row.AttributeType;
                break;

            case "BirthDate":
                BirthDate = Row.AttributeType;
                break;

            case "Role":
                Role = Row.AttributeType;

                Output0Buffer.AddRow();
                Output0Buffer.ID = ID;
                Output0Buffer.Role = Role;
                Output0Buffer.BirthDate = BirthDate;

                break;
            default:
                break;
        }
    }
}

1. 将输出"列映射到OLE DB目标