Index: DISDB.conmgr
===================================================================
diff -u
--- DISDB.conmgr (revision 0)
+++ DISDB.conmgr (revision 55fcea97b2c8a42d920083e39cf1001f81125606)
@@ -0,0 +1,10 @@
+
+
+
+
+
+
\ No newline at end of file
Index: ERPDISDB.conmgr
===================================================================
diff -u
--- ERPDISDB.conmgr (revision 0)
+++ ERPDISDB.conmgr (revision 55fcea97b2c8a42d920083e39cf1001f81125606)
@@ -0,0 +1,10 @@
+
+
+
+
+
+
\ No newline at end of file
Index: Employees.dtsx
===================================================================
diff -u
--- Employees.dtsx (revision 0)
+++ Employees.dtsx (revision 55fcea97b2c8a42d920083e39cf1001f81125606)
@@ -0,0 +1,2809 @@
+
+
+ 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
+
+
+
+]]>
+
\ No newline at end of file
Index: Orchestration.dtsx
===================================================================
diff -u
--- Orchestration.dtsx (revision 0)
+++ Orchestration.dtsx (revision 55fcea97b2c8a42d920083e39cf1001f81125606)
@@ -0,0 +1,351 @@
+
+
+ 8
+
+
+
+
+
+
+
+
+
+
+
+
+
+ True
+ Employees.dtsx
+
+
+
+
+
+
+
+ True
+ Products.dtsx
+
+
+
+
+
+
+
+ True
+ ReleasedProducts.dtsx
+
+
+
+
+
+
+
+ True
+ VendorAddresses.dtsx
+
+
+
+
+
+
+
+ True
+ Vendors.dtsx
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+]]>
+
\ No newline at end of file
Index: ProductCategory.dtsx
===================================================================
diff -u
--- ProductCategory.dtsx (revision 0)
+++ ProductCategory.dtsx (revision 55fcea97b2c8a42d920083e39cf1001f81125606)
@@ -0,0 +1,1659 @@
+
+
+ 8
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+ DataResults$
+
+
+ 0
+ false
+ false
+
+ 2147483647
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+ [dbo].[ProductCategory]
+
+
+
+ 1252
+ false
+ 0
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+ [dbo].[ProductCategory]
+
+
+ 1252
+ false
+ 3
+ false
+ false
+ TABLOCK,CHECK_CONSTRAINTS
+ 2147483647
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 0
+
+
+ SELECT
+CONVERT(NVARCHAR(250),'Brand') AS PRODUCTCATEGORYHIERARCHYNAME,
+CONVERT(NVARCHAR(250),tab_desc) AS CATEGORYNAME,
+CONVERT(NVARCHAR(250),tab_code) AS CATEGORYCODE,
+CONVERT(NVARCHAR(250),'') AS CATEGORYDESCRIPTION,
+CONVERT(NVARCHAR(250),'') AS CATEGORYKEYWORDS,
+CONVERT(NVARCHAR(250),'') AS DEFAULTPROJECTGLOBALCATEGORYID,
+CONVERT(NVARCHAR(250),'New category') AS FRIENDLYCATEGORYNAME,
+CONVERT(NVARCHAR(250),'No') AS ISCATEGORYINHERITINGPARENTCATEGORYATTRIBUTES,
+CONVERT(NVARCHAR(250),'No') AS ISCATEGORYINHERITINGPARENTPRODUCTATTRIBUTES,
+CONVERT(NVARCHAR(250),'No') AS ISTANGIBLEPRODUCT,
+CONVERT(NVARCHAR(250),'') AS PARENTPRODUCTCATEGORYCODE,
+CONVERT(NVARCHAR(250),'Brands') AS PARENTPRODUCTCATEGORYNAME,
+CONVERT(NVARCHAR(250),'') AS PROJECTCATEGORYNAME
+FROM dbo.tables
+WHERE tab_type = 'BRANDS' and [tab_code] <> 'LASTBRAND'
+
+ 1252
+ false
+ 2
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ DataSourceViewID
+
+
+ TableInfoObjectType
+ Table
+
+
+
+
+
+
+ DataSourceViewID
+
+
+ TableInfoObjectType
+ Table
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ DataSourceViewID
+
+
+
+
+
+
+ DataSourceViewID
+
+
+ TableInfoObjectType
+ Table
+
+
+
+]]>
+
\ No newline at end of file