<?xml version="1.0" encoding="utf-16"?>
<DTS xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <UserVariables>
    <UserVariable>
      <Name>ownerID</Name>
      <HelpText />
      <PromptText />
      <DataType>string</DataType>
      <Formula>?58</Formula>
      <Prompted>false</Prompted>
    </UserVariable>
    <UserVariable>
      <Name>createdbyID</Name>
      <HelpText />
      <PromptText />
      <DataType>string</DataType>
      <Formula>S16</Formula>
      <Prompted>false</Prompted>
    </UserVariable>
    <UserVariable>
      <Name>modifiedbyID</Name>
      <HelpText />
      <PromptText />
      <DataType>string</DataType>
      <Formula>S17</Formula>
      <Prompted>false</Prompted>
    </UserVariable>
  </UserVariables>
  <TargetVariables>
    <TargetVariable>
      <Name>stepOwnerID</Name>
      <HelpText />
      <Type>S</Type>
      <DataObject>vhacrm_employee</DataObject>
      <DataField>vhacrm_employeeid</DataField>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
    </TargetVariable>
    <TargetVariable>
      <Name>stepcreatedbyID</Name>
      <HelpText />
      <Type>S</Type>
      <DataObject>vhacrm_employee(2)</DataObject>
      <DataField>vhacrm_employeeid</DataField>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
    </TargetVariable>
    <TargetVariable>
      <Name>stepmodifiedbyID</Name>
      <HelpText />
      <Type>S</Type>
      <DataObject>vhacrm_employee(3)</DataObject>
      <DataField>vhacrm_employeeid</DataField>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
    </TargetVariable>
  </TargetVariables>
  <JobInfo>
    <JobName />
    <JobDescription />
    <CreatedBy />
    <JobVersion />
    <HelpFile />
    <SourceDescription />
    <StepsDescription />
    <Version>26</Version>
    <VersionCompat>26</VersionCompat>
  </JobInfo>
  <KXRef>
    <Location>0</Location>
    <Database>0</Database>
    <Table />
    <SrcKey />
    <srcXRef />
    <TgtStep />
    <TgtKey />
    <TgtXref />
    <Label />
    <Variable />
    <SrcKeyDelimiter />
    <TgtKeyDelimiter />
    <SrcName />
    <SrcNameXRef />
    <TgtName />
    <TgtNameXref />
    <SrcNameDelimiter />
    <TgtNameDelimiter />
    <TgtDatabase />
  </KXRef>
  <UpdateStats>
    <Start>NO</Start>
    <End>NO</End>
    <State>AFTER % DEGRADE</State>
    <AfterNRows>1000</AfterNRows>
    <EveryNRows>1000</EveryNRows>
    <AfterDegradation>25</AfterDegradation>
  </UpdateStats>
  <Options>
    <GroupBy />
    <CommitEvery>NONE</CommitEvery>
    <NextJob>6.1 Case Notes.dts</NextJob>
    <ShowPercentComplete>NO</ShowPercentComplete>
    <TurboTextMode>YES</TurboTextMode>
    <AsyncOperations>NO</AsyncOperations>
    <CancelIfNoRows>NO</CancelIfNoRows>
    <CancelIfPercentSkip>NO</CancelIfPercentSkip>
    <PercentSkip>50</PercentSkip>
    <OutputSkipRows />
    <SkipRowServer />
    <SkipRowPrefix />
    <AllowMultiRecordUpdates>NO</AllowMultiRecordUpdates>
    <VariableInsert />
    <VariableUpdate />
    <VariableDelete />
    <CompareFieldsOnUpdates>NO</CompareFieldsOnUpdates>
    <SkipRowOwner />
    <OverrideSkipRowConnectionInfo>NO</OverrideSkipRowConnectionInfo>
    <CommitRowCount>0</CommitRowCount>
    <LogSuccessfulOperations />
    <LogOutcomes />
    <InternalDbUsage />
    <InternalDbLabel />
  </Options>
  <Source>
    <SourceQuery>SELECT CN.[CN ID]
      , CN.[CN CREATED]
      , CN.[CN LST UPD]
      , CN.[CN CREATED BY]
      , CN.[CN LST UPD BY]
      , CN.[CN SR ID]
      , CN.[CN TYPE]
      , CN.[CN NOTE]
      , CN.[CN STATUS]
      , CN.[CN SR INFO]
      , CN.[recordid]
      , CN.[sequenceid]
      , CN.[datecreated]
      , CN.[errormessage]
      , CN.[importstatus], CRMEMP.[CRM_GUID] AS CREATEDBY, b.[CRM_GUID] AS MODIFIEDBY, c.CRM_GUID AS OWNERGUID, c.EMP_ID AS OWNERID
FROM CN_DATA AS CN
LEFT OUTER JOIN CRMEMP_DATA AS CRMEMP
ON CRMEMP.[EMP_ID] = CN.[CN CREATED BY]
LEFT OUTER JOIN CRMEMP_DATA AS b
ON b.[EMP_ID] = CN.[CN LST UPD BY]
LEFT OUTER JOIN SRREQ_DATA AS REQ
ON REQ.[ROW ID] = CN.[CN SR ID]
LEFT OUTER JOIN CRMEMP_DATA AS c
ON c.EMP_ID = REQ.[SR OWNER ID]</SourceQuery>
    <ModifySourceOperation>3</ModifySourceOperation>
    <ModifySourceField>importstatus</ModifySourceField>
    <ModifySourceValue>IF ( ISEMPTY (GETROWERROR()), "Processed", "Failure")</ModifySourceValue>
    <KeyFields />
    <KeyFieldsDelimiter />
    <NameFields />
    <NameFieldsDelimater />
    <UserVariables />
  </Source>
  <SourceFields>
    <SourceField>
      <Name>CN ID</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S1</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>CN CREATED</Name>
      <DataObject />
      <Type>char(25)</Type>
      <Reference>S2</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>CN LST UPD</Name>
      <DataObject />
      <Type>char(25)</Type>
      <Reference>S3</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>CN CREATED BY</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S4</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>CN LST UPD BY</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S5</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>CN SR ID</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S6</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>CN TYPE</Name>
      <DataObject />
      <Type>char(220)</Type>
      <Reference>S7</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>CN NOTE</Name>
      <DataObject />
      <Type>long varchar</Type>
      <Reference>S8</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>CN STATUS</Name>
      <DataObject />
      <Type>char(255)</Type>
      <Reference>S9</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>CN SR INFO</Name>
      <DataObject />
      <Type>char(50)</Type>
      <Reference>S10</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>recordid</Name>
      <DataObject />
      <Type>char(38)</Type>
      <Reference>S11</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>sequenceid</Name>
      <DataObject />
      <Type>decimal(8)</Type>
      <Reference>S12</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>datecreated</Name>
      <DataObject />
      <Type>datetime(16)</Type>
      <Reference>S13</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>errormessage</Name>
      <DataObject />
      <Type>char(250)</Type>
      <Reference>S14</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>importstatus</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S15</Reference>
      <IsLink>false</IsLink>
    </SourceField>
    <SourceField>
      <Name>CREATEDBY</Name>
      <DataObject />
      <Type>char(40)</Type>
      <Reference>S16</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>MODIFIEDBY</Name>
      <DataObject />
      <Type>char(40)</Type>
      <Reference>S17</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>OWNERGUID</Name>
      <DataObject />
      <Type>char(40)</Type>
      <Reference>S18</Reference>
      <IsLink>true</IsLink>
    </SourceField>
    <SourceField>
      <Name>OWNERID</Name>
      <DataObject />
      <Type>char(15)</Type>
      <Reference>S19</Reference>
      <IsLink>true</IsLink>
    </SourceField>
  </SourceFields>
  <DataProviders>
    <DataProvider>
      <Usage>ST</Usage>
      <Label>Scribe Internal Database</Label>
      <Type />
      <Vendor />
      <Name />
      <User />
      <Password />
      <Server />
      <ConnectParams />
      <AccessLibrary>0</AccessLibrary>
      <OverrideConnectInfo />
      <AdapterDbID />
      <Comment>This is the Scribe application database.  Use InternalDB.exe found in your Scribe install directory to make changes to this connection. WARNING: Changes to this database could result in application instability.  You should use this connection in your integration solutions if you are very familiar with the Scribe database schema.</Comment>
      <UseLabelAsNames />
      <IgnoreKSyncTables />
      <PromptForReconnect>NO</PromptForReconnect>
      <ReuseConnection>NO</ReuseConnection>
      <PreJobScript />
      <PostJobScript />
      <CanEditConnection>NO</CanEditConnection>
      <CanPromptForReconnect>NO</CanPromptForReconnect>
      <CanRename>NO</CanRename>
      <CanDelete>NO</CanDelete>
      <CanReuseConnection>NO</CanReuseConnection>
      <TextFile>NO</TextFile>
      <Unicodeconnection />
      <WinAuthImpersonate />
      <Properties />
    </DataProvider>
    <DataProvider>
      <Usage>T</Usage>
      <Label>Adapter for Dynamics CRM</Label>
      <Type>Db</Type>
      <Vendor />
      <Name>vrmcloud\</Name>
      <User>acollier</User>
      <Password>1853A1A216E999976C7A0F14C59B2DBE</Password>
      <Server>https://DNS        .hrc.dev.crm.vrm.vba.DNS   /DNS  M</Server>
      <ConnectParams />
      <AccessLibrary>0</AccessLibrary>
      <OverrideConnectInfo>NO</OverrideConnectInfo>
      <AdapterDbID>Scribe.DynamicsCrm5.Adapter.DynamicsCrmDatabase</AdapterDbID>
      <Comment />
      <UseLabelAsNames>NO</UseLabelAsNames>
      <IgnoreKSyncTables>NO</IgnoreKSyncTables>
      <PromptForReconnect>NO</PromptForReconnect>
      <ReuseConnection>YES</ReuseConnection>
      <PreJobScript />
      <PostJobScript />
      <CanEditConnection>YES</CanEditConnection>
      <CanPromptForReconnect>YES</CanPromptForReconnect>
      <CanRename>YES</CanRename>
      <CanDelete>YES</CanDelete>
      <CanReuseConnection>YES</CanReuseConnection>
      <TextFile>NO</TextFile>
      <Unicodeconnection>NO</Unicodeconnection>
      <WinAuthImpersonate>NO</WinAuthImpersonate>
      <Properties>
        <AdapterProperty>
          <Name>Organization</Name>
          <Value>DNS  M</Value>
          <IsConnectionProperty>Y</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>AuthType</Name>
          <Value>ActiveDirectory</Value>
          <IsConnectionProperty>Y</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>TrimStringData</Name>
          <Value>N</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>ValidateAgainstPickList</Name>
          <Value>N</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>UseRunAsUser</Name>
          <Value>N</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>RunAsUserName</Name>
          <Value />
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>RunAsUserID</Name>
          <Value>00000000-0000-0000-0000-000000000000</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>DefaultOwnerName</Name>
          <Value />
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>DefaultOwnerID</Name>
          <Value>00000000-0000-0000-0000-000000000000</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>DefaultOwnerType</Name>
          <Value>0</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>QueryBatchSize</Name>
          <Value>100</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>TimeZoneOption</Name>
          <Value>1</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>ThreadCount</Name>
          <Value>32</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>UseBulkApi</Name>
          <Value>N</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
        <AdapterProperty>
          <Name>SkipPreSeek</Name>
          <Value>N</Value>
          <IsConnectionProperty>N</IsConnectionProperty>
          <Flags>0</Flags>
        </AdapterProperty>
      </Properties>
    </DataProvider>
  </DataProviders>
  <TargetTables>
    <TargetTable>
      <Name>vhacrm_employee</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>8</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <ConflictFormula />
      <ConflictValue />
      <Success0Action>G</Success0Action>
      <Success0Step>3</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>C</Success1Action>
      <Success1Step>0</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>S</Success2Action>
      <Success2Step>0</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>Y</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>2</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF( ISERROR(S18), TRUE(), SKIPSTEP())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Dynamics CRM.vhacrm_employee owner</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>CRMEMP_DATA</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>8</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>Scribe Internal Database</DataProvider>
      <ConflictFormula />
      <ConflictValue />
      <Success0Action>C</Success0Action>
      <Success0Step>0</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>C</Success1Action>
      <Success1Step>0</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>S</Success2Action>
      <Success2Step>0</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>Y</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF( ISERROR(S18), TRUE(), SKIPSTEP())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.CRMEMP_DATA owner</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>vhacrm_employee(2)</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>8</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <ConflictFormula />
      <ConflictValue />
      <Success0Action>G</Success0Action>
      <Success0Step>5</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>C</Success1Action>
      <Success1Step>0</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>S</Success2Action>
      <Success2Step>0</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>Y</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>2</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF( ISERROR(S16), TRUE(), SKIPSTEP())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Dynamics CRM.vhacrm_employee createdby</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>CRMEMP_DATA(2)</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>8</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>Scribe Internal Database</DataProvider>
      <ConflictFormula />
      <ConflictValue />
      <Success0Action>C</Success0Action>
      <Success0Step>0</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>C</Success1Action>
      <Success1Step>0</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>S</Success2Action>
      <Success2Step>0</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>Y</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF( ISERROR(S16), TRUE(), SKIPSTEP())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.CRMEMP_DATA createdby</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>vhacrm_employee(3)</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>8</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <ConflictFormula />
      <ConflictValue />
      <Success0Action>C</Success0Action>
      <Success0Step>0</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>C</Success1Action>
      <Success1Step>0</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>S</Success2Action>
      <Success2Step>0</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>Y</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>2</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF( ISERROR(S17), TRUE(), SKIPSTEP())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Dynamics CRM.vhacrm_employee modified by</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>CRMEMP_DATA(3)</Name>
      <Operation>I</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>G</FailureAction>
      <FailureStep>8</FailureStep>
      <FailureMessage>Application defined error</FailureMessage>
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>Scribe Internal Database</DataProvider>
      <ConflictFormula />
      <ConflictValue />
      <Success0Action>C</Success0Action>
      <Success0Step>0</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>C</Success1Action>
      <Success1Step>0</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>S</Success2Action>
      <Success2Step>0</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>Y</Success2ReportError>
      <FailureExitStatus>2</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula>IF( ISERROR(S17), TRUE(), SKIPSTEP())</PreOpFormula>
      <PreOpValue>#SKIPSTEP!</PreOpValue>
      <StepName>Scribe Internal Database.CRMEMP_DATA modifiedby</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>CN_DATA</Name>
      <Operation>U</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>S</FailureAction>
      <FailureStep>0</FailureStep>
      <FailureMessage />
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>Scribe Internal Database</DataProvider>
      <ConflictFormula />
      <ConflictValue />
      <Success0Action>S</Success0Action>
      <Success0Step>0</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>S</Success1Action>
      <Success1Step>0</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>S</Success2Action>
      <Success2Step>0</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>Y</Success2ReportError>
      <FailureExitStatus>0</FailureExitStatus>
      <Success0ExitStatus>2</Success0ExitStatus>
      <Success1ExitStatus>2</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula />
      <PreOpValue />
      <StepName>Scribe Internal Database.CN_DATA SUCCESS</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
    <TargetTable>
      <Name>CN_DATA(2)</Name>
      <Operation>U</Operation>
      <KeyFields />
      <Conflicts>A</Conflicts>
      <ConflictedField />
      <Nulls>0</Nulls>
      <SkipFields>-</SkipFields>
      <OnFailure>S</OnFailure>
      <BreakGroup />
      <FailureAction>S</FailureAction>
      <FailureStep>0</FailureStep>
      <FailureMessage />
      <FailureCommit>NONE</FailureCommit>
      <FailureReportError>Y</FailureReportError>
      <DataProvider>Scribe Internal Database</DataProvider>
      <ConflictFormula />
      <ConflictValue />
      <Success0Action>C</Success0Action>
      <Success0Step>0</Success0Step>
      <Success0Message />
      <Success0Commit>NONE</Success0Commit>
      <Success0ReportError>N</Success0ReportError>
      <Success1Action>C</Success1Action>
      <Success1Step>0</Success1Step>
      <Success1Message />
      <Success1Commit>NONE</Success1Commit>
      <Success1ReportError>N</Success1ReportError>
      <Success2Action>S</Success2Action>
      <Success2Step>0</Success2Step>
      <Success2Message />
      <Success2Commit>NONE</Success2Commit>
      <Success2ReportError>Y</Success2ReportError>
      <FailureExitStatus>0</FailureExitStatus>
      <Success0ExitStatus>0</Success0ExitStatus>
      <Success1ExitStatus>0</Success1ExitStatus>
      <Success2ExitStatus>0</Success2ExitStatus>
      <PreOpFormula />
      <PreOpValue />
      <StepName>Scribe Internal Database.CN_DATA FAILURE</StepName>
      <StepDescription />
      <AllowAFKAssign>1</AllowAFKAssign>
      <BulkMode>NO</BulkMode>
      <BulkSize>100</BulkSize>
    </TargetTable>
  </TargetTables>
  <Keys>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S11</SourceField>
      <TargetDataObject>CN_DATA</TargetDataObject>
      <TargetField>recordid</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>recordid</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S11</LookupExpression>
      <SourceFormula>S11</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
    <Key>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceField>S11</SourceField>
      <TargetDataObject>CN_DATA(2)</TargetDataObject>
      <TargetField>recordid</TargetField>
      <TargetValue>0</TargetValue>
      <TargetExpression>recordid</TargetExpression>
      <Operator>EQUALS</Operator>
      <LookupExpression>S11</LookupExpression>
      <SourceFormula>S11</SourceFormula>
      <ScalarFunction />
      <Parameter1 />
      <Paramter2 />
      <ApplyTo>TARGET</ApplyTo>
    </Key>
  </Keys>
  <Links>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S4</SourceFields>
      <TargetDataObject>vhacrm_employee(2)</TargetDataObject>
      <TargetField>vhacrm_siebelid_text</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S4</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S5</SourceFields>
      <TargetDataObject>vhacrm_employee(3)</TargetDataObject>
      <TargetField>vhacrm_siebelid_text</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S5</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_employee</TargetDataObject>
      <TargetField>vhacrm_lastname_text</TargetField>
      <TargetValue>Employee</TargetValue>
      <Formula>"Employee"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_employee</TargetDataObject>
      <TargetField>vhacrm_firstname_text</TargetField>
      <TargetValue>Former</TargetValue>
      <Formula>"Former"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_employee</TargetDataObject>
      <TargetField>vhacrm_fullname_text</TargetField>
      <TargetValue>Former Employee</TargetValue>
      <Formula>"Former Employee"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_employee(2)</TargetDataObject>
      <TargetField>vhacrm_fullname_text</TargetField>
      <TargetValue>Former Employee</TargetValue>
      <Formula>"Former Employee"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_employee(2)</TargetDataObject>
      <TargetField>vhacrm_lastname_text</TargetField>
      <TargetValue>Employee</TargetValue>
      <Formula>"Employee"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_employee(2)</TargetDataObject>
      <TargetField>vhacrm_firstname_text</TargetField>
      <TargetValue>Former</TargetValue>
      <Formula>"Former"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_employee(3)</TargetDataObject>
      <TargetField>vhacrm_fullname_text</TargetField>
      <TargetValue>Former Employee</TargetValue>
      <Formula>"Former Employee"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_employee(3)</TargetDataObject>
      <TargetField>vhacrm_lastname_text</TargetField>
      <TargetValue>Employee</TargetValue>
      <Formula>"Employee"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>vhacrm_employee(3)</TargetDataObject>
      <TargetField>vhacrm_firstname_text</TargetField>
      <TargetValue>Former</TargetValue>
      <Formula>"Former"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA</TargetDataObject>
      <TargetField>CRM_GUID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>stepOwnerID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA</TargetDataObject>
      <TargetField>recordid</TargetField>
      <TargetValue>27FFE6CE-160D-4880-9D66-34C9F7226E87</TargetValue>
      <Formula>GUID()</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA</TargetDataObject>
      <TargetField>EMP_FN</TargetField>
      <TargetValue>Former</TargetValue>
      <Formula>"Former"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA</TargetDataObject>
      <TargetField>EMP_LN</TargetField>
      <TargetValue>Employee</TargetValue>
      <Formula>"Employee"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA</TargetDataObject>
      <TargetField>importstatus</TargetField>
      <TargetValue>uploaded</TargetValue>
      <Formula>"uploaded"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA(2)</TargetDataObject>
      <TargetField>EMP_LN</TargetField>
      <TargetValue>Employee</TargetValue>
      <Formula>"Employee"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA(2)</TargetDataObject>
      <TargetField>EMP_FN</TargetField>
      <TargetValue>Former</TargetValue>
      <Formula>"Former"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA(2)</TargetDataObject>
      <TargetField>CRM_GUID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>stepcreatedbyID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA(2)</TargetDataObject>
      <TargetField>recordid</TargetField>
      <TargetValue>2BFA9D06-A58F-43CA-A282-F33CCF20596F</TargetValue>
      <Formula>GUID()</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA(2)</TargetDataObject>
      <TargetField>importstatus</TargetField>
      <TargetValue>uploaded</TargetValue>
      <Formula>"uploaded"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA(3)</TargetDataObject>
      <TargetField>EMP_LN</TargetField>
      <TargetValue>Employee</TargetValue>
      <Formula>"Employee"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA(3)</TargetDataObject>
      <TargetField>EMP_FN</TargetField>
      <TargetValue>Former</TargetValue>
      <Formula>"Former"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA(3)</TargetDataObject>
      <TargetField>CRM_GUID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>stepmodifiedbyID</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA(3)</TargetDataObject>
      <TargetField>recordid</TargetField>
      <TargetValue>82B3A632-5DCA-4A07-B7B7-4F64B4CB1F08</TargetValue>
      <Formula>GUID()</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CRMEMP_DATA(3)</TargetDataObject>
      <TargetField>importstatus</TargetField>
      <TargetValue>uploaded</TargetValue>
      <Formula>"uploaded"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S19</SourceFields>
      <TargetDataObject>CRMEMP_DATA</TargetDataObject>
      <TargetField>EMP_ID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S19</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S4</SourceFields>
      <TargetDataObject>CRMEMP_DATA(2)</TargetDataObject>
      <TargetField>EMP_ID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S4</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S5</SourceFields>
      <TargetDataObject>CRMEMP_DATA(3)</TargetDataObject>
      <TargetField>EMP_ID</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S5</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Adapter for Dynamics CRM</DataProvider>
      <Comment />
      <Flag />
      <SourceFields>S19</SourceFields>
      <TargetDataObject>vhacrm_employee</TargetDataObject>
      <TargetField>vhacrm_siebelid_text</TargetField>
      <TargetValue>0</TargetValue>
      <Formula>S19</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CN_DATA</TargetDataObject>
      <TargetField>importstatus</TargetField>
      <TargetValue>Processed</TargetValue>
      <Formula>"Processed"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CN_DATA(2)</TargetDataObject>
      <TargetField>importstatus</TargetField>
      <TargetValue>Failure</TargetValue>
      <Formula>"Failure"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
    <Link>
      <DataProvider>Scribe Internal Database</DataProvider>
      <Comment />
      <Flag />
      <SourceFields />
      <TargetDataObject>CN_DATA(2)</TargetDataObject>
      <TargetField>errormessage</TargetField>
      <TargetValue>Case Note Employee record failed</TargetValue>
      <Formula>"Case Note Employee record failed"</Formula>
      <Overwrite>true</Overwrite>
    </Link>
  </Links>
</DTS>