8 0 0 0 [dbo].[Employees] 1252 false 0 false false 2147483647

select * from [dbo].[Employees] select * from (select * from [dbo].[Employees]) [refTable] where [refTable].[LegacyEmployeeCode] = ? 0 0 1 0 25 25 <referenceMetadata><referenceColumns><referenceColumn name="PERSONNELNUMBER" dataType="DT_WSTR" length="200" precision="0" scale="0" codePage="0"/><referenceColumn name="EMPLOYMENTLEGALENTITYID" dataType="DT_WSTR" length="200" precision="0" scale="0" codePage="0"/><referenceColumn name="PARTYNUMBER" dataType="DT_WSTR" length="200" precision="0" scale="0" codePage="0"/><referenceColumn name="NAMESEQUENCEDISPLAYAS" dataType="DT_WSTR" length="200" precision="0" scale="0" codePage="0"/><referenceColumn name="PARTYTYPE" dataType="DT_WSTR" length="200" precision="0" scale="0" codePage="0"/><referenceColumn name="FIRSTNAME" dataType="DT_WSTR" length="200" precision="0" scale="0" codePage="0"/><referenceColumn name="MIDDLENAME" dataType="DT_WSTR" length="200" precision="0" scale="0" codePage="0"/><referenceColumn name="LASTNAME" dataType="DT_WSTR" length="200" precision="0" scale="0" codePage="0"/><referenceColumn name="LegacyEmployeeCode" dataType="DT_WSTR" length="250" precision="0" scale="0" codePage="0"/></referenceColumns></referenceMetadata> #{Package\Employees DFT\OLE DB Source MAILUSER.Outputs[OLE DB Source Output].Columns[LegacyEmployeeCode]}; 1252 false LegacyEmployeeCode

0 UPDATE [dbo].[Employees] SET [EMPLOYMENTLEGALENTITYID] = ?,[FIRSTNAME] = ?,[LASTNAME] = ?,[MIDDLENAME] = ?,[NAMESEQUENCEDISPLAYAS] = ?, EMPLOYMENTSTARTDATE = ? WHERE [LegacyEmployeeCode] = ? 1252 65 65 65 65 65 65 65

0 SELECT CAST(CONCAT('PSNNUM',RIGHT(CONVERT(CHAR(9),ROW_NUMBER() OVER (ORDER BY t.tab_add_dte) + 100000000),8)) AS NVARCHAR(200)) AS PERSONNELNUMBER, CAST('LMC' AS NVARCHAR(200)) AS EMPLOYMENTLEGALENTITYID, CAST(CONCAT('PTY',RIGHT(CONVERT(CHAR(10),ROW_NUMBER() OVER (ORDER BY t.tab_add_dte) + 1000000000 + ?),9)) AS NVARCHAR(200)) AS PARTYNUMBER, CAST('LastCommaFirst' AS NVARCHAR(200)) AS NAMESEQUENCEDISPLAYAS, CAST('Person' AS NVARCHAR(200)) AS PARTYTYPE, CAST(SUBSTRING(T.tab_desc,37,15) AS NVARCHAR(200)) AS FIRSTNAME, CAST(SUBSTRING(T.tab_desc,52,1) AS NVARCHAR(200)) AS MIDDLENAME, CAST(SUBSTRING(T.tab_desc,53,15) AS NVARCHAR(200)) AS LASTNAME, CAST(CASE WHEN t.tab_add_dte = 0 THEN '' ELSE '' END AS NVARCHAR(200)) AS EMPLOYMENTSTARTDATE, CAST(t.tab_code AS NVARCHAR(200)) AS LegacyEmployeeCode FROM dbo.tables t WHERE t.tab_type = 'MAILUSER' AND SUBSTRING(T.tab_desc,37,15) <> 'ACCOUNTS' 1252 false 2 "Parameter0:Input",{2A35B3A4-4B22-450A-B6DD-0C01AD721578};

0 SELECT DISTINCT CAST('LMC' AS NVARCHAR(200)) AS EMPLOYMENTLEGALENTITYID, CAST('LastCommaFirst' AS NVARCHAR(200)) AS NAMESEQUENCEDISPLAYAS, CAST('Person' AS NVARCHAR(200)) AS PARTYTYPE, CAST(LEFT(sman_name,CHARINDEX(' ',sman_name)) AS NVARCHAR(200)) AS FIRSTNAME, CAST('' AS NVARCHAR(200)) AS MIDDLENAME, CAST(SUBSTRING(sman_name,CHARINDEX(' ',sman_name), CASE WHEN CHARINDEX('(',sman_name) <> 0 THEN CHARINDEX('(',sman_name) - CHARINDEX(' ',sman_name) ELSE LEN(sman_name) END) AS NVARCHAR(200)) AS LASTNAME, CAST('' AS NVARCHAR(200)) AS EMPLOYMENTSTARTDATE, CAST(CASE WHEN LEN(sman_id) = 4 THEN LEFT(sman_id,3) WHEN sman_id = 'EX' THEN sman_id ELSE LEFT(sman_id,LEN(RTRIM(sman_id)) - PATINDEX('%[A-Z]%',RIGHT(RTRIM(sman_id),1))) END AS NVARCHAR(200)) AS LegacyEmployeeCode FROM [DISDB].[dbo].[salesman] WHERE sman_date_quit = 0 AND sman_name NOT LIKE 'Open%' AND sman_name NOT LIKE 'International%' AND sman_name NOT LIKE 'Parts%' AND sman_name NOT LIKE 'Employee%' AND sman_name NOT LIKE 'Sample%' AND sman_name NOT LIKE 'Thor%' AND sman_name NOT LIKE 'Vendor%' AND sman_name NOT LIKE 'Drag%' AND sman_name NOT LIKE 'Reps%' AND sman_name NOT LIKE 'Slippery%' 1252 false 2

#{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[PERSONNELNUMBER]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[EMPLOYMENTLEGALENTITYID]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[PARTYNUMBER]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[NAMESEQUENCEDISPLAYAS]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[PARTYTYPE]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[FIRSTNAME]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[MIDDLENAME]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[LASTNAME]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[LegacyEmployeeCode]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[EMPLOYMENTSTARTDATE]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[EMPLOYMENTLEGALENTITYID]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[NAMESEQUENCEDISPLAYAS]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[PARTYTYPE]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[FIRSTNAME]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[MIDDLENAME]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[LASTNAME]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[LegacyEmployeeCode]} #{Package\Employees DFT\Union All.Outputs[Union All Output 1].Columns[EMPLOYMENTSTARTDATE]}

0 DataResults$ 0 false false 2147483647

0 [dbo].[Employees] 1252 false 0

DataSourceViewID OverwriteParamsSQLProp false UsedTableName [dbo].[Employees] TableInfoObjectType 0 DataSourceViewID DataSourceViewID TableInfoObjectType Table DataSourceViewID DataSourceViewID TableInfoObjectType Table DataSourceViewID TableInfoObjectType Table ]]>