Home Explore Help
Register Sign In
ETL
/
ME_ORION_TO_DWH
4
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 4cd3d6c694
Branches Tags
ME_ORION_TO_...
/
ORION_TO_DWH
/
ORION_TO_DWH.dtproj

ORION_TO_DWH.dtproj 26 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445 
  1. <?xml version="1.0" encoding="utf-8"?>
    2. 

  2. <Project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    3. 

  3.   <DeploymentModel>Project</DeploymentModel>
    4. 

  4.   <ProductVersion>15.0.1100.123</ProductVersion>
    5. 

  5.   <SchemaVersion>9.0.1.0</SchemaVersion>
    6. 

  6.   <State>$base64$PFNvdXJjZUNvbnRyb2xJbmZvIHhtbG5zOnhzZD0iaHR0cDovL3d3dy53My5vcmcvMjAwMS9YTUxTY2hlbWEiIHhtbG5zOnhzaT0iaHR0cDovL3d3dy53My5vcmcvMjAwMS9YTUxTY2hlbWEtaW5zdGFuY2UiIHhtbG5zOmRkbDI9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDAzL2VuZ2luZS8yIiB4bWxuczpkZGwyXzI9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDAzL2VuZ2luZS8yLzIiIHhtbG5zOmRkbDEwMF8xMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDA4L2VuZ2luZS8xMDAvMTAwIiB4bWxuczpkZGwyMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEwL2VuZ2luZS8yMDAiIHhtbG5zOmRkbDIwMF8yMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEwL2VuZ2luZS8yMDAvMjAwIiB4bWxuczpkZGwzMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDExL2VuZ2luZS8zMDAiIHhtbG5zOmRkbDMwMF8zMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDExL2VuZ2luZS8zMDAvMzAwIiB4bWxuczpkZGw0MDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEyL2VuZ2luZS80MDAiIHhtbG5zOmRkbDQwMF80MDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEyL2VuZ2luZS80MDAvNDAwIiB4bWxuczpkZGw1MDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEzL2VuZ2luZS81MDAiIHhtbG5zOmRkbDUwMF81MDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEzL2VuZ2luZS81MDAvNTAwIiB4bWxuczpkd2Q9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vRGF0YVdhcmVob3VzZS9EZXNpZ25lci8xLjAiPg0KICA8RW5hYmxlZD5mYWxzZTwvRW5hYmxlZD4NCiAgPFByb2plY3ROYW1lPjwvUHJvamVjdE5hbWU+DQogIDxBdXhQYXRoPjwvQXV4UGF0aD4NCiAgPExvY2FsUGF0aD48L0xvY2FsUGF0aD4NCiAgPFByb3ZpZGVyPjwvUHJvdmlkZXI+DQo8L1NvdXJjZUNvbnRyb2xJbmZvPg==</State>
    7. 

  7.   <Database>
    8. 

  8.     <Name>ORION_TO_DWH.database</Name>
    9. 

  9.     <FullPath>ORION_TO_DWH.database</FullPath>
    10. 

  10.   </Database>
    11. 

  11.   <DataSources />
    12. 

  12.   <DataSourceViews />
    13. 

  13.   <DeploymentModelSpecificContent>
    14. 

  14.     <Manifest>
    15. 

  15.       <SSIS:Project SSIS:ProtectionLevel="EncryptSensitiveWithUserKey" xmlns:SSIS="www.microsoft.com/SqlServer/SSIS">
    16. 

  16.         <SSIS:Properties>
    17. 

  17.           <SSIS:Property SSIS:Name="ID">{7835392a-5365-412a-ba65-55bef9d9095c}</SSIS:Property>
    18. 

  18.           <SSIS:Property SSIS:Name="Name">ORION_TO_DWH</SSIS:Property>
    19. 

  19.           <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
    20. 

  20.           <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
    21. 

  21.           <SSIS:Property SSIS:Name="VersionBuild">0</SSIS:Property>
    22. 

  22.           <SSIS:Property SSIS:Name="VersionComments">
    23. 

  23.           </SSIS:Property>
    24. 

  24.           <SSIS:Property SSIS:Name="CreationDate">2019-05-13T13:50:18.8383225-06:00</SSIS:Property>
    25. 

  25.           <SSIS:Property SSIS:Name="CreatorName">GRUPOME\rnieto</SSIS:Property>
    26. 

  26.           <SSIS:Property SSIS:Name="CreatorComputerName">NIETO</SSIS:Property>
    27. 

  27.           <SSIS:Property SSIS:Name="Description">
    28. 

  28.           </SSIS:Property>
    29. 

  29.           <SSIS:Property SSIS:Name="PasswordVerifier" SSIS:Sensitive="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAGIEOdGgKWU6YNT7yo8y0BAAAAAACAAAAAAADZgAAwAAAABAAAAD1dqsznSwXjMDBilbQjVBIAAAAAASAAACgAAAAEAAAAPNAH+Wz7TtBpa/qNZ/qF4uIAAAAZkX+FBH3k9htT8VeywgRzaH1ykxMQbBMPMljtBavBjtzY0nOxv7BPhgPrt7+aV+k2pFosD5ybqCoGEJdLWK9JPWTPP4gwzfjVReLl162LNTAcDEuAQC1/gUVpnJ55OVxHR9r8h4q0BmFJbBrxoJhFGwctID7RenhHryIt1p7i8DqwY/6k7Si6RQAAACOZRrvfme1OjXDV2ZgmRpCcKhANw==</SSIS:Property>
    30. 

  30.           <SSIS:Property SSIS:Name="FormatVersion">1</SSIS:Property>
    31. 

  31.         </SSIS:Properties>
    32. 

  32.         <SSIS:Packages>
    33. 

  33.           <SSIS:Package SSIS:Name="DIM_AGENTES.dtsx" SSIS:EntryPoint="1" />
    34. 

  34.           <SSIS:Package SSIS:Name="DIM_PROYECTOS.dtsx" SSIS:EntryPoint="1" />
    35. 

  35.           <SSIS:Package SSIS:Name="FACT_INGRESOS_UT_INY.dtsx" SSIS:EntryPoint="1" />
    36. 

  36.           <SSIS:Package SSIS:Name="FACT_COSTOS_UT_INY.dtsx" SSIS:EntryPoint="1" />
    37. 

  37.           <SSIS:Package SSIS:Name="FACT_INGRESOS_EOR_INY.dtsx" SSIS:EntryPoint="1" />
    38. 

  38.           <SSIS:Package SSIS:Name="FACT_COSTOS_EOR_INY.dtsx" SSIS:EntryPoint="1" />
    39. 

  39.           <SSIS:Package SSIS:Name="FACT_COSTOS_PROVEEDORES_INY.dtsx" SSIS:EntryPoint="1" />
    40. 

  40.           <SSIS:Package SSIS:Name="FACT_COSTOS_UT_RET.dtsx" SSIS:EntryPoint="1" />
    41. 

  41.           <SSIS:Package SSIS:Name="FACT_COSTOS_EOR_RET.dtsx" SSIS:EntryPoint="1" />
    42. 

  42.           <SSIS:Package SSIS:Name="FACT_INGRESOS_EOR_RET.dtsx" SSIS:EntryPoint="1" />
    43. 

  43.           <SSIS:Package SSIS:Name="FACT_INGRESOS_CLIENTES_RET.dtsx" SSIS:EntryPoint="1" />
    44. 

  44.         </SSIS:Packages>
    45. 

  45.         <SSIS:ConnectionManagers>
    46. 

  46.           <SSIS:ConnectionManager SSIS:Name="ORION.conmgr" />
    47. 

  47.           <SSIS:ConnectionManager SSIS:Name="DWH_ME.conmgr" />
    48. 

  48.         </SSIS:ConnectionManagers>
    49. 

  49.         <SSIS:DeploymentInfo>
    50. 

  50.           <SSIS:ProjectConnectionParameters>
    51. 

  51.             <SSIS:Parameter SSIS:Name="CM.ORION.ConnectionString">
    52. 

  52.               <SSIS:Properties>
    53. 

  53.                 <SSIS:Property SSIS:Name="ID">
    54. 

  54.                 </SSIS:Property>
    55. 

  55.                 <SSIS:Property SSIS:Name="CreationName">
    56. 

  56.                 </SSIS:Property>
    57. 

  57.                 <SSIS:Property SSIS:Name="Description">
    58. 

  58.                 </SSIS:Property>
    59. 

  59.                 <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
    60. 

  60.                 <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
    61. 

  61.                 <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
    62. 

  62.                 <SSIS:Property SSIS:Name="Value">Data Source=192.168.98.207;User ID=ETL_DWH;Initial Catalog=PRD_ORION;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=False;</SSIS:Property>
    63. 

  63.                 <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
    64. 

  64.               </SSIS:Properties>
    65. 

  65.             </SSIS:Parameter>
    66. 

  66.             <SSIS:Parameter SSIS:Name="CM.ORION.InitialCatalog">
    67. 

  67.               <SSIS:Properties>
    68. 

  68.                 <SSIS:Property SSIS:Name="ID">
    69. 

  69.                 </SSIS:Property>
    70. 

  70.                 <SSIS:Property SSIS:Name="CreationName">
    71. 

  71.                 </SSIS:Property>
    72. 

  72.                 <SSIS:Property SSIS:Name="Description">
    73. 

  73.                 </SSIS:Property>
    74. 

  74.                 <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
    75. 

  75.                 <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
    76. 

  76.                 <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
    77. 

  77.                 <SSIS:Property SSIS:Name="Value">PRD_ORION</SSIS:Property>
    78. 

  78.                 <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
    79. 

  79.               </SSIS:Properties>
    80. 

  80.             </SSIS:Parameter>
    81. 

  81.             <SSIS:Parameter SSIS:Name="CM.ORION.Password">
    82. 

  82.               <SSIS:Properties>
    83. 

  83.                 <SSIS:Property SSIS:Name="ID">
    84. 

  84.                 </SSIS:Property>
    85. 

  85.                 <SSIS:Property SSIS:Name="CreationName">
    86. 

  86.                 </SSIS:Property>
    87. 

  87.                 <SSIS:Property SSIS:Name="Description">
    88. 

  88.                 </SSIS:Property>
    89. 

  89.                 <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
    90. 

  90.                 <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
    91. 

  91.                 <SSIS:Property SSIS:Name="Sensitive">1</SSIS:Property>
    92. 

  92.                 <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
    93. 

  93.               </SSIS:Properties>
    94. 

  94.             </SSIS:Parameter>
    95. 

  95.             <SSIS:Parameter SSIS:Name="CM.ORION.RetainSameConnection">
    96. 

  96.               <SSIS:Properties>
    97. 

  97.                 <SSIS:Property SSIS:Name="ID">
    98. 

  98.                 </SSIS:Property>
    99. 

  99.                 <SSIS:Property SSIS:Name="CreationName">
    100. 

  100.                 </SSIS:Property>
    101. 

  101.                 <SSIS:Property SSIS:Name="Description">
    102. 

  102.                 </SSIS:Property>
    103. 

  103.                 <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
    104. 

  104.                 <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
    105. 

  105.                 <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
    106. 

  106.                 <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
    107. 

  107.                 <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
    108. 

  108.               </SSIS:Properties>
    109. 

  109.             </SSIS:Parameter>
    110. 

  110.             <SSIS:Parameter SSIS:Name="CM.ORION.ServerName">
    111. 

  111.               <SSIS:Properties>
    112. 

  112.                 <SSIS:Property SSIS:Name="ID">
    113. 

  113.                 </SSIS:Property>
    114. 

  114.                 <SSIS:Property SSIS:Name="CreationName">
    115. 

  115.                 </SSIS:Property>
    116. 

  116.                 <SSIS:Property SSIS:Name="Description">
    117. 

  117.                 </SSIS:Property>
    118. 

  118.                 <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
    119. 

  119.                 <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
    120. 

  120.                 <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
    121. 

  121.                 <SSIS:Property SSIS:Name="Value">192.168.98.207</SSIS:Property>
    122. 

  122.                 <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
    123. 

  123.               </SSIS:Properties>
    124. 

  124.             </SSIS:Parameter>
    125. 

  125.             <SSIS:Parameter SSIS:Name="CM.ORION.UserName">
    126. 

  126.               <SSIS:Properties>
    127. 

  127.                 <SSIS:Property SSIS:Name="ID">
    128. 

  128.                 </SSIS:Property>
    129. 

  129.                 <SSIS:Property SSIS:Name="CreationName">
    130. 

  130.                 </SSIS:Property>
    131. 

  131.                 <SSIS:Property SSIS:Name="Description">
    132. 

  132.                 </SSIS:Property>
    133. 

  133.                 <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
    134. 

  134.                 <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
    135. 

  135.                 <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
    136. 

  136.                 <SSIS:Property SSIS:Name="Value">ETL_DWH</SSIS:Property>
    137. 

  137.                 <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
    138. 

  138.               </SSIS:Properties>
    139. 

  139.             </SSIS:Parameter>
    140. 

  140.             <SSIS:Parameter SSIS:Name="CM.DWH_ME.ConnectionString">
    141. 

  141.               <SSIS:Properties>
    142. 

  142.                 <SSIS:Property SSIS:Name="ID">
    143. 

  143.                 </SSIS:Property>
    144. 

  144.                 <SSIS:Property SSIS:Name="CreationName">
    145. 

  145.                 </SSIS:Property>
    146. 

  146.                 <SSIS:Property SSIS:Name="Description">
    147. 

  147.                 </SSIS:Property>
    148. 

  148.                 <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
    149. 

  149.                 <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
    150. 

  150.                 <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
    151. 

  151.                 <SSIS:Property SSIS:Name="Value">Data Source=192.168.98.23;User ID=sa;Initial Catalog=DEV_DWH_MERELEC;Provider=SQLNCLI11.1;Persist Security Info=True;Auto Translate=False;</SSIS:Property>
    152. 

  152.                 <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
    153. 

  153.               </SSIS:Properties>
    154. 

  154.             </SSIS:Parameter>
    155. 

  155.             <SSIS:Parameter SSIS:Name="CM.DWH_ME.InitialCatalog">
    156. 

  156.               <SSIS:Properties>
    157. 

  157.                 <SSIS:Property SSIS:Name="ID">
    158. 

  158.                 </SSIS:Property>
    159. 

  159.                 <SSIS:Property SSIS:Name="CreationName">
    160. 

  160.                 </SSIS:Property>
    161. 

  161.                 <SSIS:Property SSIS:Name="Description">
    162. 

  162.                 </SSIS:Property>
    163. 

  163.                 <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
    164. 

  164.                 <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
    165. 

  165.                 <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
    166. 

  166.                 <SSIS:Property SSIS:Name="Value">DEV_DWH_MERELEC</SSIS:Property>
    167. 

  167.                 <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
    168. 

  168.               </SSIS:Properties>
    169. 

  169.             </SSIS:Parameter>
    170. 

  170.             <SSIS:Parameter SSIS:Name="CM.DWH_ME.Password">
    171. 

  171.               <SSIS:Properties>
    172. 

  172.                 <SSIS:Property SSIS:Name="ID">
    173. 

  173.                 </SSIS:Property>
    174. 

  174.                 <SSIS:Property SSIS:Name="CreationName">
    175. 

  175.                 </SSIS:Property>
    176. 

  176.                 <SSIS:Property SSIS:Name="Description">
    177. 

  177.                 </SSIS:Property>
    178. 

  178.                 <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
    179. 

  179.                 <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
    180. 

  180.                 <SSIS:Property SSIS:Name="Sensitive">1</SSIS:Property>
    181. 

  181.                 <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
    182. 

  182.               </SSIS:Properties>
    183. 

  183.             </SSIS:Parameter>
    184. 

  184.             <SSIS:Parameter SSIS:Name="CM.DWH_ME.RetainSameConnection">
    185. 

  185.               <SSIS:Properties>
    186. 

  186.                 <SSIS:Property SSIS:Name="ID">
    187. 

  187.                 </SSIS:Property>
    188. 

  188.                 <SSIS:Property SSIS:Name="CreationName">
    189. 

  189.                 </SSIS:Property>
    190. 

  190.                 <SSIS:Property SSIS:Name="Description">
    191. 

  191.                 </SSIS:Property>
    192. 

  192.                 <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
    193. 

  193.                 <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
    194. 

  194.                 <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
    195. 

  195.                 <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
    196. 

  196.                 <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
    197. 

  197.               </SSIS:Properties>
    198. 

  198.             </SSIS:Parameter>
    199. 

  199.             <SSIS:Parameter SSIS:Name="CM.DWH_ME.ServerName">
    200. 

  200.               <SSIS:Properties>
    201. 

  201.                 <SSIS:Property SSIS:Name="ID">
    202. 

  202.                 </SSIS:Property>
    203. 

  203.                 <SSIS:Property SSIS:Name="CreationName">
    204. 

  204.                 </SSIS:Property>
    205. 

  205.                 <SSIS:Property SSIS:Name="Description">
    206. 

  206.                 </SSIS:Property>
    207. 

  207.                 <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
    208. 

  208.                 <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
    209. 

  209.                 <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
    210. 

  210.                 <SSIS:Property SSIS:Name="Value">192.168.98.23</SSIS:Property>
    211. 

  211.                 <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
    212. 

  212.               </SSIS:Properties>
    213. 

  213.             </SSIS:Parameter>
    214. 

  214.             <SSIS:Parameter SSIS:Name="CM.DWH_ME.UserName">
    215. 

  215.               <SSIS:Properties>
    216. 

  216.                 <SSIS:Property SSIS:Name="ID">
    217. 

  217.                 </SSIS:Property>
    218. 

  218.                 <SSIS:Property SSIS:Name="CreationName">
    219. 

  219.                 </SSIS:Property>
    220. 

  220.                 <SSIS:Property SSIS:Name="Description">
    221. 

  221.                 </SSIS:Property>
    222. 

  222.                 <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
    223. 

  223.                 <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
    224. 

  224.                 <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
    225. 

  225.                 <SSIS:Property SSIS:Name="Value">sa</SSIS:Property>
    226. 

  226.                 <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
    227. 

  227.               </SSIS:Properties>
    228. 

  228.             </SSIS:Parameter>
    229. 

  229.           </SSIS:ProjectConnectionParameters>
    230. 

  230.           <SSIS:PackageInfo>
    231. 

  231.             <SSIS:PackageMetaData SSIS:Name="DIM_AGENTES.dtsx">
    232. 

  232.               <SSIS:Properties>
    233. 

  233.                 <SSIS:Property SSIS:Name="ID">{16A2C4FF-0DA0-43A7-8D10-AB3AAE614551}</SSIS:Property>
    234. 

  234.                 <SSIS:Property SSIS:Name="Name">DIM_AGENTES</SSIS:Property>
    235. 

  235.                 <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
    236. 

  236.                 <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
    237. 

  237.                 <SSIS:Property SSIS:Name="VersionBuild">74</SSIS:Property>
    238. 

  238.                 <SSIS:Property SSIS:Name="VersionComments">
    239. 

  239.                 </SSIS:Property>
    240. 

  240.                 <SSIS:Property SSIS:Name="VersionGUID">{6E2472E0-3007-4F0D-A3E4-A32439788974}</SSIS:Property>
    241. 

  241.                 <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
    242. 

  242.                 <SSIS:Property SSIS:Name="Description">
    243. 

  243.                 </SSIS:Property>
    244. 

  244.                 <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
    245. 

  245.               </SSIS:Properties>
    246. 

  246.               <SSIS:Parameters />
    247. 

  247.             </SSIS:PackageMetaData>
    248. 

  248.             <SSIS:PackageMetaData SSIS:Name="DIM_PROYECTOS.dtsx">
    249. 

  249.               <SSIS:Properties>
    250. 

  250.                 <SSIS:Property SSIS:Name="ID">{94C87ECB-9F62-44AC-894A-7C2B6DC0C472}</SSIS:Property>
    251. 

  251.                 <SSIS:Property SSIS:Name="Name">DIM_PROYECTOS</SSIS:Property>
    252. 

  252.                 <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
    253. 

  253.                 <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
    254. 

  254.                 <SSIS:Property SSIS:Name="VersionBuild">93</SSIS:Property>
    255. 

  255.                 <SSIS:Property SSIS:Name="VersionComments">
    256. 

  256.                 </SSIS:Property>
    257. 

  257.                 <SSIS:Property SSIS:Name="VersionGUID">{302020FA-0D45-402F-AA46-5D4E35D1A00F}</SSIS:Property>
    258. 

  258.                 <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
    259. 

  259.                 <SSIS:Property SSIS:Name="Description">
    260. 

  260.                 </SSIS:Property>
    261. 

  261.                 <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
    262. 

  262.               </SSIS:Properties>
    263. 

  263.               <SSIS:Parameters />
    264. 

  264.             </SSIS:PackageMetaData>
    265. 

  265.             <SSIS:PackageMetaData SSIS:Name="FACT_INGRESOS_UT_INY.dtsx">
    266. 

  266.               <SSIS:Properties>
    267. 

  267.                 <SSIS:Property SSIS:Name="ID">{5C270E70-06F1-4F5A-87EB-F218B05F8F0A}</SSIS:Property>
    268. 

  268.                 <SSIS:Property SSIS:Name="Name">FACT_INGRESOS_UT_INY</SSIS:Property>
    269. 

  269.                 <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
    270. 

  270.                 <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
    271. 

  271.                 <SSIS:Property SSIS:Name="VersionBuild">70</SSIS:Property>
    272. 

  272.                 <SSIS:Property SSIS:Name="VersionComments">
    273. 

  273.                 </SSIS:Property>
    274. 

  274.                 <SSIS:Property SSIS:Name="VersionGUID">{21982C87-9EAD-44AF-A193-FA96306B7BD6}</SSIS:Property>
    275. 

  275.                 <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
    276. 

  276.                 <SSIS:Property SSIS:Name="Description">
    277. 

  277.                 </SSIS:Property>
    278. 

  278.                 <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
    279. 

  279.               </SSIS:Properties>
    280. 

  280.               <SSIS:Parameters />
    281. 

  281.             </SSIS:PackageMetaData>
    282. 

  282.             <SSIS:PackageMetaData SSIS:Name="FACT_COSTOS_UT_INY.dtsx">
    283. 

  283.               <SSIS:Properties>
    284. 

  284.                 <SSIS:Property SSIS:Name="ID">{C87D0BD3-5FD1-4EB9-B57A-3FB02541E3BC}</SSIS:Property>
    285. 

  285.                 <SSIS:Property SSIS:Name="Name">FACT_COSTOS_UT_INY</SSIS:Property>
    286. 

  286.                 <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
    287. 

  287.                 <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
    288. 

  288.                 <SSIS:Property SSIS:Name="VersionBuild">36</SSIS:Property>
    289. 

  289.                 <SSIS:Property SSIS:Name="VersionComments">
    290. 

  290.                 </SSIS:Property>
    291. 

  291.                 <SSIS:Property SSIS:Name="VersionGUID">{DEAD8E94-D60A-4A6A-95FE-91AFB0438491}</SSIS:Property>
    292. 

  292.                 <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
    293. 

  293.                 <SSIS:Property SSIS:Name="Description">
    294. 

  294.                 </SSIS:Property>
    295. 

  295.                 <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
    296. 

  296.               </SSIS:Properties>
    297. 

  297.               <SSIS:Parameters />
    298. 

  298.             </SSIS:PackageMetaData>
    299. 

  299.             <SSIS:PackageMetaData SSIS:Name="FACT_INGRESOS_EOR_INY.dtsx">
    300. 

  300.               <SSIS:Properties>
    301. 

  301.                 <SSIS:Property SSIS:Name="ID">{6262B267-CD6E-48AD-8CB8-18E89A2D7282}</SSIS:Property>
    302. 

  302.                 <SSIS:Property SSIS:Name="Name">FACT_INGRESOS_EOR_INY</SSIS:Property>
    303. 

  303.                 <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
    304. 

  304.                 <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
    305. 

  305.                 <SSIS:Property SSIS:Name="VersionBuild">39</SSIS:Property>
    306. 

  306.                 <SSIS:Property SSIS:Name="VersionComments">
    307. 

  307.                 </SSIS:Property>
    308. 

  308.                 <SSIS:Property SSIS:Name="VersionGUID">{1964FE71-7365-4044-950D-234CB60343D7}</SSIS:Property>
    309. 

  309.                 <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
    310. 

  310.                 <SSIS:Property SSIS:Name="Description">
    311. 

  311.                 </SSIS:Property>
    312. 

  312.                 <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
    313. 

  313.               </SSIS:Properties>
    314. 

  314.               <SSIS:Parameters />
    315. 

  315.             </SSIS:PackageMetaData>
    316. 

  316.             <SSIS:PackageMetaData SSIS:Name="FACT_COSTOS_EOR_INY.dtsx">
    317. 

  317.               <SSIS:Properties>
    318. 

  318.                 <SSIS:Property SSIS:Name="ID">{74C3353E-B5F0-4164-848B-35FD46ABC789}</SSIS:Property>
    319. 

  319.                 <SSIS:Property SSIS:Name="Name">FACT_COSTOS_EOR_INY</SSIS:Property>
    320. 

  320.                 <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
    321. 

  321.                 <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
    322. 

  322.                 <SSIS:Property SSIS:Name="VersionBuild">38</SSIS:Property>
    323. 

  323.                 <SSIS:Property SSIS:Name="VersionComments">
    324. 

  324.                 </SSIS:Property>
    325. 

  325.                 <SSIS:Property SSIS:Name="VersionGUID">{6135067E-B556-4E28-8EE3-BA8F42EA71FA}</SSIS:Property>
    326. 

  326.                 <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
    327. 

  327.                 <SSIS:Property SSIS:Name="Description">
    328. 

  328.                 </SSIS:Property>
    329. 

  329.                 <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
    330. 

  330.               </SSIS:Properties>
    331. 

  331.               <SSIS:Parameters />
    332. 

  332.             </SSIS:PackageMetaData>
    333. 

  333.             <SSIS:PackageMetaData SSIS:Name="FACT_COSTOS_PROVEEDORES_INY.dtsx">
    334. 

  334.               <SSIS:Properties>
    335. 

  335.                 <SSIS:Property SSIS:Name="ID">{0E35BB1C-81EE-439C-A707-977E03A3D54C}</SSIS:Property>
    336. 

  336.                 <SSIS:Property SSIS:Name="Name">FACT_COSTOS_PROVEEDORES_INY</SSIS:Property>
    337. 

  337.                 <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
    338. 

  338.                 <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
    339. 

  339.                 <SSIS:Property SSIS:Name="VersionBuild">18</SSIS:Property>
    340. 

  340.                 <SSIS:Property SSIS:Name="VersionComments">
    341. 

  341.                 </SSIS:Property>
    342. 

  342.                 <SSIS:Property SSIS:Name="VersionGUID">{AD4BDF66-02C2-4D48-8BCC-B667ACB5C055}</SSIS:Property>
    343. 

  343.                 <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
    344. 

  344.                 <SSIS:Property SSIS:Name="Description">
    345. 

  345.                 </SSIS:Property>
    346. 

  346.                 <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
    347. 

  347.               </SSIS:Properties>
    348. 

  348.               <SSIS:Parameters />
    349. 

  349.             </SSIS:PackageMetaData>
    350. 

  350.             <SSIS:PackageMetaData SSIS:Name="FACT_COSTOS_UT_RET.dtsx">
    351. 

  351.               <SSIS:Properties>
    352. 

  352.                 <SSIS:Property SSIS:Name="ID">{A0F6C4B8-A071-409D-B4D1-0A86815839C0}</SSIS:Property>
    353. 

  353.                 <SSIS:Property SSIS:Name="Name">FACT_COSTOS_UT_RET</SSIS:Property>
    354. 

  354.                 <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
    355. 

  355.                 <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
    356. 

  356.                 <SSIS:Property SSIS:Name="VersionBuild">24</SSIS:Property>
    357. 

  357.                 <SSIS:Property SSIS:Name="VersionComments">
    358. 

  358.                 </SSIS:Property>
    359. 

  359.                 <SSIS:Property SSIS:Name="VersionGUID">{12E0A4E3-520F-4757-97AC-632BD1503736}</SSIS:Property>
    360. 

  360.                 <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
    361. 

  361.                 <SSIS:Property SSIS:Name="Description">
    362. 

  362.                 </SSIS:Property>
    363. 

  363.                 <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
    364. 

  364.               </SSIS:Properties>
    365. 

  365.               <SSIS:Parameters />
    366. 

  366.             </SSIS:PackageMetaData>
    367. 

  367.             <SSIS:PackageMetaData SSIS:Name="FACT_COSTOS_EOR_RET.dtsx">
    368. 

  368.               <SSIS:Properties>
    369. 

  369.                 <SSIS:Property SSIS:Name="ID">{DFF2E171-1C03-4CAD-8101-1A71278F4848}</SSIS:Property>
    370. 

  370.                 <SSIS:Property SSIS:Name="Name">FACT_COSTOS_EOR_RET</SSIS:Property>
    371. 

  371.                 <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
    372. 

  372.                 <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
    373. 

  373.                 <SSIS:Property SSIS:Name="VersionBuild">42</SSIS:Property>
    374. 

  374.                 <SSIS:Property SSIS:Name="VersionComments">
    375. 

  375.                 </SSIS:Property>
    376. 

  376.                 <SSIS:Property SSIS:Name="VersionGUID">{4B9277E6-A19E-4569-8A9B-B0029ECF9674}</SSIS:Property>
    377. 

  377.                 <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
    378. 

  378.                 <SSIS:Property SSIS:Name="Description">
    379. 

  379.                 </SSIS:Property>
    380. 

  380.                 <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
    381. 

  381.               </SSIS:Properties>
    382. 

  382.               <SSIS:Parameters />
    383. 

  383.             </SSIS:PackageMetaData>
    384. 

  384.             <SSIS:PackageMetaData SSIS:Name="FACT_INGRESOS_EOR_RET.dtsx">
    385. 

  385.               <SSIS:Properties>
    386. 

  386.                 <SSIS:Property SSIS:Name="ID">{F7512355-CA0C-4528-A79E-9920126B29B4}</SSIS:Property>
    387. 

  387.                 <SSIS:Property SSIS:Name="Name">Package1</SSIS:Property>
    388. 

  388.                 <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
    389. 

  389.                 <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
    390. 

  390.                 <SSIS:Property SSIS:Name="VersionBuild">15</SSIS:Property>
    391. 

  391.                 <SSIS:Property SSIS:Name="VersionComments">
    392. 

  392.                 </SSIS:Property>
    393. 

  393.                 <SSIS:Property SSIS:Name="VersionGUID">{C961B297-E859-4C25-9193-6CBCD924C52A}</SSIS:Property>
    394. 

  394.                 <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
    395. 

  395.                 <SSIS:Property SSIS:Name="Description">
    396. 

  396.                 </SSIS:Property>
    397. 

  397.                 <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
    398. 

  398.               </SSIS:Properties>
    399. 

  399.               <SSIS:Parameters />
    400. 

  400.             </SSIS:PackageMetaData>
    401. 

  401.             <SSIS:PackageMetaData SSIS:Name="FACT_INGRESOS_CLIENTES_RET.dtsx">
    402. 

  402.               <SSIS:Properties>
    403. 

  403.                 <SSIS:Property SSIS:Name="ID">{FEFD5E75-14EF-4845-9794-2DD9DD2801AC}</SSIS:Property>
    404. 

  404.                 <SSIS:Property SSIS:Name="Name">FACT_INGRESOS_CLIENTES_RET</SSIS:Property>
    405. 

  405.                 <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
    406. 

  406.                 <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
    407. 

  407.                 <SSIS:Property SSIS:Name="VersionBuild">10</SSIS:Property>
    408. 

  408.                 <SSIS:Property SSIS:Name="VersionComments">
    409. 

  409.                 </SSIS:Property>
    410. 

  410.                 <SSIS:Property SSIS:Name="VersionGUID">{0DBF7CC5-EB54-44D0-B1A5-171D209FBDAC}</SSIS:Property>
    411. 

  411.                 <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
    412. 

  412.                 <SSIS:Property SSIS:Name="Description">
    413. 

  413.                 </SSIS:Property>
    414. 

  414.                 <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
    415. 

  415.               </SSIS:Properties>
    416. 

  416.               <SSIS:Parameters />
    417. 

  417.             </SSIS:PackageMetaData>
    418. 

  418.           </SSIS:PackageInfo>
    419. 

  419.         </SSIS:DeploymentInfo>
    420. 

  420.       </SSIS:Project>
    421. 

  421.     </Manifest>
    422. 

  422.   </DeploymentModelSpecificContent>
    423. 

  423.   <ControlFlowParts />
    424. 

  424.   <Miscellaneous />
    425. 

  425.   <Configurations>
    426. 

  426.     <Configuration>
    427. 

  427.       <Name>Development</Name>
    428. 

  428.       <Options>
    429. 

  429.         <OutputPath>bin</OutputPath>
    430. 

  430.         <ConnectionMappings />
    431. 

  431.         <ConnectionProviderMappings />
    432. 

  432.         <ConnectionSecurityMappings />
    433. 

  433.         <DatabaseStorageLocations />
    434. 

  434.         <TargetServerVersion>SQLServer2017</TargetServerVersion>
    435. 

  435.         <ParameterConfigurationValues>
    436. 

  436.           <ConfigurationSetting>
    437. 

  437.             <Id>LastModifiedTime</Id>
    438. 

  438.             <Name>LastModifiedTime</Name>
    439. 

  439.             <Value xsi:type="xsd:dateTime">2019-05-13T19:59:42.2251468Z</Value>
    440. 

  440.           </ConfigurationSetting>
    441. 

  441.         </ParameterConfigurationValues>
    442. 

  442.       </Options>
    443. 

  443.     </Configuration>
    444. 

  444.   </Configurations>
    445. 

  445. </Project>
    446.