Get new column value using Ms Sql autoincrement and SQL and keep referential integrity

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Get new column value using Ms Sql autoincrement and SQL and keep referential integrity</name>
     <script>mssql_keys</script>
     <allow>EXTRACT_LOAD</allow> 
     <driver>com.toolsverse.etl.driver.sqlserver.MsSqlDriver</driver>

<tasks>
           <task>
              <name>drop_table</name>
              <connection>dest</connection> 
              <class>com.toolsverse.etl.core.task.common.SqlTask</class>
              <sql>
                  drop table config_property_test;
              </sql>
              <onexception action="ignore"/>
           </task>

<task>
              <name>create_table</name>
              <connection>dest</connection> 
              <class>com.toolsverse.etl.core.task.common.SqlTask</class>
              <sql>
                 create table config_property_test
                 (
                      CONFIG_PROPERTY_NUM INT PRIMARY KEY IDENTITY,
                      NAME	VARCHAR(255),
                      DESCRIPTION	VARCHAR(255),	
                      DEFAULT_VALUE	VARCHAR(255),
                      CFG_PROP_NUM INT
                 )      
              </sql>
           </task>     
      </tasks>

<sources>
          <source>
               <name>config_property</name>
               <extract>
                    <sql>select config_property.*, config_property_num as config_num, config_property_num as cfg_prop_num from config_property</sql>
               </extract>
          </source>
          <source>
               <name>config_value</name>
               <extract>
                    <sql>select * from config_value</sql>
               </extract>
          </source>
          <source>
               <name>second_config_value</name>
               <extract>
                    <sql>select config_property_num as con_prop_num, value from config_value</sql>
               </extract>
          </source>          
     </sources>
     <destinations>
          <destination>
               <name>config_property_test</name>
               <source>config_property</source>
               <metadata>yes</metadata>
               <load>
                   <variables>
                       <CONFIG_NUM include="false" />
                       
                       <CONFIG_PROPERTY_NUM function="getAutoInc" />
                       
                       <CFG_PROP_NUM function="getPk" sql="{CONFIG_NUM} + 1000" />
                   </variables>
               </load>
          </destination>
          <destination>
               <name>config_value_test</name>
               <source>config_value</source>
               <metadata>yes</metadata>
               <load>
                   <variables>
                       <CONFIG_PROPERTY_NUM function="getFk" />
                   </variables>
               </load>
          </destination>

<destination>
               <name>second_config_value</name>
               <metadata>yes</metadata>
               <load>
                   <variables>
                         
                       <CON_PROP_NUM function="getFk" field="CFG_PROP_NUM" />
                   </variables>
               </load>
          </destination>          
     </destinations>
</scenario>