从一个包含所有数据的表中创建多个命名和结构化的表

Question

我有一个这样的表：

element code    name    seq active
assessmentCategory  1   Entry   NULL    True
assessmentCategory  2   On-Going    NULL    True
assessmentCategory  3   Exit    NULL    True
careerCluster   01  Agriculture NULL    True
careerCluster   02  Architecture and Construction   NULL    True
careerCluster   03  Arts and Communications NULL    True
careerCluster   04  Business and Management NULL    True
careerCluster   05  Education and Training  NULL    True
careerCluster   06  Finance NULL    True
careerCluster   07  Govermant and Public Administration NULL    True
careerCluster   08  Health Science  NULL    True
careerCluster   09  Hospitality and Tourism NULL    True
careerCluster   10  Human Service   NULL    True
careerCluster   11  Information Technology  NULL    True
careerCluster   12  Law and Public Safety   NULL    True
careerCluster   13  Manufacturing   NULL    True
careerCluster   14  Marketing, Sales and service    NULL    True
careerCluster   15  Science and Technology  NULL    True
careerCluster   16  Transportation and Logistics    NULL    True
cte FT  Full Time CTE Student   1   True
cte PT  Part Time CTE Student   2   True
disability1 05  Gifted without Disability (no longer reported)  NULL    False
disability1 2105    Gifted without Disability   0   False
disability1 2106    Gifted with Disability  0   False
disability1 2121    Autistic/Autism NULL    True
disability1 2122    Deaf-blindness  NULL    True
disability1 2123    Hearing impairment including deafness   NULL    True
disability1 2124    Intellectual Disability NULL    True
disability1 2125    Multiple disabilities   NULL    True
disability1 2126    Orthopedic impairment   NULL    True
disability1 2127    Emotional disturbance   NULL    True
disability1 2128    Specific learning disability    NULL    True
disability1 2129    Speech or language impairment   NULL    True
disability1 2130    Traumatic brain injury  NULL    True
disability1 2131    Visual impairment including blindness   NULL    True
disability1 2132    Other health impairment NULL    True
disability1 2134    Developmental delay NULL    True
disability1 2135    Infants and Toddlers with Disabilities  NULL    True
disability2 05  Gifted without Disability (no longer reported)  NULL    False
disability2 2105    Gifted without Disability   0   False

如何使用SSIS或TSQL创建以元素列中的唯一值命名并包含code、name、seq和active列中的值的新表？