Transfer table DMAP Table from BPMC Schema 1.2.X to 2.1.X

Cause When you are upgrading BPMC from old Schema like 1.2.X, the transport utility will not import the DMAP table due to big schema change. 

How to Solve. SELECT [LineNum] ,[Feed_Name] ,[Pass] ,[New_Column_Name] ,[New_Column_ContentType] ,[New_Column_Content] ,[New_Column_DataType] ,cast(null as nvarchar(20)) as [Auto_Header_Override] ,[Active] ,case when [Advanced_Transformation]='ColumnToRow_Consol' then 'ColumnsToRow' else [Advanced_Transformation] end as [Advanced_Transformation] ,[Compress_Participation] ,[CTOR_Column_Name] ,[CTOR_Column_ContentType] ,[CTOR_Column_Content] ,[CTOR_Column_DataType] ,[CTOR_Condition] ,cast(null as nvarchar(20)) as [Comments] FROM [BPMConnect].[dbo].[CONFIG_DMAP] Use Import data wizard and use above Query as Source, For \