ofertas_mer_ut.dtproj 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  3. <DeploymentModel>Project</DeploymentModel>
  4. <ProductVersion>12.0.2430.0</ProductVersion>
  5. <SchemaVersion>9.0.1.0</SchemaVersion>
  6. <State>$base64$PFNvdXJjZUNvbnRyb2xJbmZvIHhtbG5zOnhzZD0iaHR0cDovL3d3dy53My5vcmcvMjAwMS9YTUxTY2hlbWEiIHhtbG5zOnhzaT0iaHR0cDovL3d3dy53My5vcmcvMjAwMS9YTUxTY2hlbWEtaW5zdGFuY2UiIHhtbG5zOmRkbDI9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDAzL2VuZ2luZS8yIiB4bWxuczpkZGwyXzI9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDAzL2VuZ2luZS8yLzIiIHhtbG5zOmRkbDEwMF8xMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDA4L2VuZ2luZS8xMDAvMTAwIiB4bWxuczpkZGwyMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEwL2VuZ2luZS8yMDAiIHhtbG5zOmRkbDIwMF8yMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEwL2VuZ2luZS8yMDAvMjAwIiB4bWxuczpkZGwzMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDExL2VuZ2luZS8zMDAiIHhtbG5zOmRkbDMwMF8zMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDExL2VuZ2luZS8zMDAvMzAwIiB4bWxuczpkZGw0MDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEyL2VuZ2luZS80MDAiIHhtbG5zOmRkbDQwMF80MDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEyL2VuZ2luZS80MDAvNDAwIiB4bWxuczpkd2Q9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vRGF0YVdhcmVob3VzZS9EZXNpZ25lci8xLjAiPg0KICA8RW5hYmxlZD5mYWxzZTwvRW5hYmxlZD4NCiAgPFByb2plY3ROYW1lPjwvUHJvamVjdE5hbWU+DQogIDxBdXhQYXRoPjwvQXV4UGF0aD4NCiAgPExvY2FsUGF0aD48L0xvY2FsUGF0aD4NCiAgPFByb3ZpZGVyPjwvUHJvdmlkZXI+DQo8L1NvdXJjZUNvbnRyb2xJbmZvPg==</State>
  7. <Database>
  8. <Name>ofertas_mer_ut.database</Name>
  9. <FullPath>ofertas_mer_ut.database</FullPath>
  10. </Database>
  11. <DataSources />
  12. <DataSourceViews />
  13. <DeploymentModelSpecificContent>
  14. <Manifest>
  15. <SSIS:Project SSIS:ProtectionLevel="EncryptSensitiveWithUserKey" xmlns:SSIS="www.microsoft.com/SqlServer/SSIS">
  16. <SSIS:Properties>
  17. <SSIS:Property SSIS:Name="ID">{1e488bf6-46b8-4028-ae00-56f70f974187}</SSIS:Property>
  18. <SSIS:Property SSIS:Name="Name">ofertas_mer_ut</SSIS:Property>
  19. <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
  20. <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
  21. <SSIS:Property SSIS:Name="VersionBuild">0</SSIS:Property>
  22. <SSIS:Property SSIS:Name="VersionComments">
  23. </SSIS:Property>
  24. <SSIS:Property SSIS:Name="CreationDate">2018-08-16T11:17:59.5299699-06:00</SSIS:Property>
  25. <SSIS:Property SSIS:Name="CreatorName">WMERCADOSME\BI4</SSIS:Property>
  26. <SSIS:Property SSIS:Name="CreatorComputerName">OLEIVA</SSIS:Property>
  27. <SSIS:Property SSIS:Name="Description">
  28. </SSIS:Property>
  29. <SSIS:Property SSIS:Name="PasswordVerifier" SSIS:Sensitive="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAKv386DGqeke8UH6ro0zEPgAAAAACAAAAAAADZgAAwAAAABAAAACdP7cfu5w+8DgavVdFlhKiAAAAAASAAACgAAAAEAAAAE35LAARhvIH1T1edoGeLEOIAAAAA9RkV7d3PnbdIbkkDjMWQosRYgVcfFS2jFAxYf8HhF1V/iNoGjku8y7mWw/q1qS1x66UN1Jqx75X6vIeZNpQ0Wl9hpDyNN/3jrpKU/LwCxFv4fQAbhRKksMhioL3ZfAIGWlveRlZoi6tGrAsYXB3Hc1klEa1kzkXaWg51y/QRSNaYy1WKZuI+BQAAAA1oawZULQmOA5sm6+bVipyOESp5Q==</SSIS:Property>
  30. <SSIS:Property SSIS:Name="FormatVersion">1</SSIS:Property>
  31. </SSIS:Properties>
  32. <SSIS:Packages>
  33. <SSIS:Package SSIS:Name="ReadExcel.dtsx" SSIS:EntryPoint="1" />
  34. </SSIS:Packages>
  35. <SSIS:ConnectionManagers>
  36. <SSIS:ConnectionManager SSIS:Name="WMERCADOS.ARGOS.conmgr" />
  37. </SSIS:ConnectionManagers>
  38. <SSIS:DeploymentInfo>
  39. <SSIS:ProjectConnectionParameters>
  40. <SSIS:Parameter SSIS:Name="CM.WMERCADOS ARGOS.ConnectionString">
  41. <SSIS:Properties>
  42. <SSIS:Property SSIS:Name="ID">
  43. </SSIS:Property>
  44. <SSIS:Property SSIS:Name="CreationName">
  45. </SSIS:Property>
  46. <SSIS:Property SSIS:Name="Description">
  47. </SSIS:Property>
  48. <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
  49. <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
  50. <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
  51. <SSIS:Property SSIS:Name="Value">Data Source=WMERCADOS;User ID=ETL_UT;Initial Catalog=PRD_ARGOS;Application Name=SSIS-ofertas_mer_ut-{8C5E392B-D49A-4982-B401-FF7F40E9398D}LocalHost.DEV_CONCILIACION;</SSIS:Property>
  52. <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
  53. </SSIS:Properties>
  54. </SSIS:Parameter>
  55. <SSIS:Parameter SSIS:Name="CM.WMERCADOS ARGOS.InitialCatalog">
  56. <SSIS:Properties>
  57. <SSIS:Property SSIS:Name="ID">
  58. </SSIS:Property>
  59. <SSIS:Property SSIS:Name="CreationName">
  60. </SSIS:Property>
  61. <SSIS:Property SSIS:Name="Description">
  62. </SSIS:Property>
  63. <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
  64. <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
  65. <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
  66. <SSIS:Property SSIS:Name="Value">PRD_ARGOS</SSIS:Property>
  67. <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
  68. </SSIS:Properties>
  69. </SSIS:Parameter>
  70. <SSIS:Parameter SSIS:Name="CM.WMERCADOS ARGOS.Password">
  71. <SSIS:Properties>
  72. <SSIS:Property SSIS:Name="ID">
  73. </SSIS:Property>
  74. <SSIS:Property SSIS:Name="CreationName">
  75. </SSIS:Property>
  76. <SSIS:Property SSIS:Name="Description">
  77. </SSIS:Property>
  78. <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
  79. <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
  80. <SSIS:Property SSIS:Name="Sensitive">1</SSIS:Property>
  81. <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
  82. </SSIS:Properties>
  83. </SSIS:Parameter>
  84. <SSIS:Parameter SSIS:Name="CM.WMERCADOS ARGOS.RetainSameConnection">
  85. <SSIS:Properties>
  86. <SSIS:Property SSIS:Name="ID">
  87. </SSIS:Property>
  88. <SSIS:Property SSIS:Name="CreationName">
  89. </SSIS:Property>
  90. <SSIS:Property SSIS:Name="Description">
  91. </SSIS:Property>
  92. <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
  93. <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
  94. <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
  95. <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
  96. <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
  97. </SSIS:Properties>
  98. </SSIS:Parameter>
  99. <SSIS:Parameter SSIS:Name="CM.WMERCADOS ARGOS.ServerName">
  100. <SSIS:Properties>
  101. <SSIS:Property SSIS:Name="ID">
  102. </SSIS:Property>
  103. <SSIS:Property SSIS:Name="CreationName">
  104. </SSIS:Property>
  105. <SSIS:Property SSIS:Name="Description">
  106. </SSIS:Property>
  107. <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
  108. <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
  109. <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
  110. <SSIS:Property SSIS:Name="Value">WMERCADOS</SSIS:Property>
  111. <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
  112. </SSIS:Properties>
  113. </SSIS:Parameter>
  114. <SSIS:Parameter SSIS:Name="CM.WMERCADOS ARGOS.UserName">
  115. <SSIS:Properties>
  116. <SSIS:Property SSIS:Name="ID">
  117. </SSIS:Property>
  118. <SSIS:Property SSIS:Name="CreationName">
  119. </SSIS:Property>
  120. <SSIS:Property SSIS:Name="Description">
  121. </SSIS:Property>
  122. <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
  123. <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
  124. <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
  125. <SSIS:Property SSIS:Name="Value">ETL_UT</SSIS:Property>
  126. <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
  127. </SSIS:Properties>
  128. </SSIS:Parameter>
  129. </SSIS:ProjectConnectionParameters>
  130. <SSIS:PackageInfo>
  131. <SSIS:PackageMetaData SSIS:Name="ReadExcel.dtsx">
  132. <SSIS:Properties>
  133. <SSIS:Property SSIS:Name="ID">{B242CAFD-9985-4132-A36F-8C48FB0F7A79}</SSIS:Property>
  134. <SSIS:Property SSIS:Name="Name">ReadExcel</SSIS:Property>
  135. <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
  136. <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
  137. <SSIS:Property SSIS:Name="VersionBuild">199</SSIS:Property>
  138. <SSIS:Property SSIS:Name="VersionComments">
  139. </SSIS:Property>
  140. <SSIS:Property SSIS:Name="VersionGUID">{BFB32C93-5576-4AF9-86D6-2DC4D69C6E77}</SSIS:Property>
  141. <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
  142. <SSIS:Property SSIS:Name="Description">
  143. </SSIS:Property>
  144. <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
  145. </SSIS:Properties>
  146. <SSIS:Parameters>
  147. <SSIS:Parameter SSIS:Name="CM.WMERCADOS.PRD_ARGOS.ETL_EOR.ConnectionString">
  148. <SSIS:Properties>
  149. <SSIS:Property SSIS:Name="ID">
  150. </SSIS:Property>
  151. <SSIS:Property SSIS:Name="CreationName">
  152. </SSIS:Property>
  153. <SSIS:Property SSIS:Name="Description">
  154. </SSIS:Property>
  155. <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
  156. <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
  157. <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
  158. <SSIS:Property SSIS:Name="Value">Data Source=WMERCADOS;User ID=ETL_EOR;Initial Catalog=PRD_ARGOS;Provider=SQLNCLI11.1;Auto Translate=False;</SSIS:Property>
  159. <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
  160. </SSIS:Properties>
  161. </SSIS:Parameter>
  162. <SSIS:Parameter SSIS:Name="CM.WMERCADOS.PRD_ARGOS.ETL_EOR.InitialCatalog">
  163. <SSIS:Properties>
  164. <SSIS:Property SSIS:Name="ID">
  165. </SSIS:Property>
  166. <SSIS:Property SSIS:Name="CreationName">
  167. </SSIS:Property>
  168. <SSIS:Property SSIS:Name="Description">
  169. </SSIS:Property>
  170. <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
  171. <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
  172. <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
  173. <SSIS:Property SSIS:Name="Value">PRD_ARGOS</SSIS:Property>
  174. <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
  175. </SSIS:Properties>
  176. </SSIS:Parameter>
  177. <SSIS:Parameter SSIS:Name="CM.WMERCADOS.PRD_ARGOS.ETL_EOR.Password">
  178. <SSIS:Properties>
  179. <SSIS:Property SSIS:Name="ID">
  180. </SSIS:Property>
  181. <SSIS:Property SSIS:Name="CreationName">
  182. </SSIS:Property>
  183. <SSIS:Property SSIS:Name="Description">
  184. </SSIS:Property>
  185. <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
  186. <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
  187. <SSIS:Property SSIS:Name="Sensitive">1</SSIS:Property>
  188. <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
  189. </SSIS:Properties>
  190. </SSIS:Parameter>
  191. <SSIS:Parameter SSIS:Name="CM.WMERCADOS.PRD_ARGOS.ETL_EOR.RetainSameConnection">
  192. <SSIS:Properties>
  193. <SSIS:Property SSIS:Name="ID">
  194. </SSIS:Property>
  195. <SSIS:Property SSIS:Name="CreationName">
  196. </SSIS:Property>
  197. <SSIS:Property SSIS:Name="Description">
  198. </SSIS:Property>
  199. <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
  200. <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
  201. <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
  202. <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
  203. <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
  204. </SSIS:Properties>
  205. </SSIS:Parameter>
  206. <SSIS:Parameter SSIS:Name="CM.WMERCADOS.PRD_ARGOS.ETL_EOR.ServerName">
  207. <SSIS:Properties>
  208. <SSIS:Property SSIS:Name="ID">
  209. </SSIS:Property>
  210. <SSIS:Property SSIS:Name="CreationName">
  211. </SSIS:Property>
  212. <SSIS:Property SSIS:Name="Description">
  213. </SSIS:Property>
  214. <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
  215. <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
  216. <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
  217. <SSIS:Property SSIS:Name="Value">WMERCADOS</SSIS:Property>
  218. <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
  219. </SSIS:Properties>
  220. </SSIS:Parameter>
  221. <SSIS:Parameter SSIS:Name="CM.WMERCADOS.PRD_ARGOS.ETL_EOR.UserName">
  222. <SSIS:Properties>
  223. <SSIS:Property SSIS:Name="ID">
  224. </SSIS:Property>
  225. <SSIS:Property SSIS:Name="CreationName">
  226. </SSIS:Property>
  227. <SSIS:Property SSIS:Name="Description">
  228. </SSIS:Property>
  229. <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
  230. <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
  231. <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
  232. <SSIS:Property SSIS:Name="Value">ETL_EOR</SSIS:Property>
  233. <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
  234. </SSIS:Properties>
  235. </SSIS:Parameter>
  236. </SSIS:Parameters>
  237. </SSIS:PackageMetaData>
  238. </SSIS:PackageInfo>
  239. </SSIS:DeploymentInfo>
  240. </SSIS:Project>
  241. </Manifest>
  242. </DeploymentModelSpecificContent>
  243. <Miscellaneous />
  244. <Configurations>
  245. <Configuration>
  246. <Name>Development</Name>
  247. <Options>
  248. <OutputPath>bin</OutputPath>
  249. <ConnectionMappings />
  250. <ConnectionProviderMappings />
  251. <ConnectionSecurityMappings />
  252. <DatabaseStorageLocations />
  253. <ParameterConfigurationValues>
  254. <ConfigurationSetting>
  255. <Id>LastModifiedTime</Id>
  256. <Name>LastModifiedTime</Name>
  257. <Value xsi:type="xsd:dateTime">2018-08-16T17:20:35.0771784Z</Value>
  258. </ConfigurationSetting>
  259. </ParameterConfigurationValues>
  260. </Options>
  261. </Configuration>
  262. </Configurations>
  263. </Project>