| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665 |
- <?xml version="1.0" encoding="utf-8"?>
- <Project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <DeploymentModel>Project</DeploymentModel>
- <ProductVersion>15.0.1300.371</ProductVersion>
- <SchemaVersion>9.0.1.0</SchemaVersion>
- <State>$base64$PFNvdXJjZUNvbnRyb2xJbmZvIHhtbG5zOnhzZD0iaHR0cDovL3d3dy53My5vcmcvMjAwMS9YTUxTY2hlbWEiIHhtbG5zOnhzaT0iaHR0cDovL3d3dy53My5vcmcvMjAwMS9YTUxTY2hlbWEtaW5zdGFuY2UiIHhtbG5zOmRkbDI9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDAzL2VuZ2luZS8yIiB4bWxuczpkZGwyXzI9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDAzL2VuZ2luZS8yLzIiIHhtbG5zOmRkbDEwMF8xMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDA4L2VuZ2luZS8xMDAvMTAwIiB4bWxuczpkZGwyMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEwL2VuZ2luZS8yMDAiIHhtbG5zOmRkbDIwMF8yMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEwL2VuZ2luZS8yMDAvMjAwIiB4bWxuczpkZGwzMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDExL2VuZ2luZS8zMDAiIHhtbG5zOmRkbDMwMF8zMDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDExL2VuZ2luZS8zMDAvMzAwIiB4bWxuczpkZGw0MDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEyL2VuZ2luZS80MDAiIHhtbG5zOmRkbDQwMF80MDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEyL2VuZ2luZS80MDAvNDAwIiB4bWxuczpkZGw1MDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEzL2VuZ2luZS81MDAiIHhtbG5zOmRkbDUwMF81MDA9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vYW5hbHlzaXNzZXJ2aWNlcy8yMDEzL2VuZ2luZS81MDAvNTAwIiB4bWxuczpkd2Q9Imh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vRGF0YVdhcmVob3VzZS9EZXNpZ25lci8xLjAiPg0KICA8RW5hYmxlZD5mYWxzZTwvRW5hYmxlZD4NCiAgPFByb2plY3ROYW1lPjwvUHJvamVjdE5hbWU+DQogIDxBdXhQYXRoPjwvQXV4UGF0aD4NCiAgPExvY2FsUGF0aD48L0xvY2FsUGF0aD4NCiAgPFByb3ZpZGVyPjwvUHJvdmlkZXI+DQo8L1NvdXJjZUNvbnRyb2xJbmZvPg==</State>
- <Database>
- <Name>ORION_TO_DWH.database</Name>
- <FullPath>ORION_TO_DWH.database</FullPath>
- </Database>
- <DataSources />
- <DataSourceViews />
- <DeploymentModelSpecificContent>
- <Manifest>
- <SSIS:Project SSIS:ProtectionLevel="EncryptSensitiveWithUserKey" xmlns:SSIS="www.microsoft.com/SqlServer/SSIS">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{7835392a-5365-412a-ba65-55bef9d9095c}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">ORION_TO_DWH</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationDate">2019-05-13T13:50:18.8383225-06:00</SSIS:Property>
- <SSIS:Property SSIS:Name="CreatorName">GRUPOME\rnieto</SSIS:Property>
- <SSIS:Property SSIS:Name="CreatorComputerName">NIETO</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="PasswordVerifier" SSIS:Sensitive="1">AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyOMVp5ESGEuVR0GQGI8zTAAAAAACAAAAAAADZgAAwAAAABAAAAD3v8+1l2uN6lUBl9os8mOmAAAAAASAAACgAAAAEAAAAOxKHhccRqGpJBEyppFHUmyIAAAA2mdFQ4rRzjGYsFrpq6vrAvobNgVVRAgUwInEyLmxxAyEPeBrOvAbPocraYLMiWxV11KJtczCAYUELzzGeVWUYYoFZxOMZFynQXK9OCBbi4to6YfRsx6HxeLaFV9Dn5vn35NnN1BZR9byLA07MHzP1w/+kAboSguzEj6qwJjBC5OT1RJzyDvQwBQAAAASi6t4IuIlTsjuG6XLMpvmv9xvpw==</SSIS:Property>
- <SSIS:Property SSIS:Name="FormatVersion">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Packages>
- <SSIS:Package SSIS:Name="DIM_AGENTES.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="DIM_PROYECTOS.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="FACT_INGRESOS_UT_INY.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="FACT_COSTOS_UT_INY.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="FACT_INGRESOS_EOR_INY.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="FACT_COSTOS_EOR_INY.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="FACT_COSTOS_PROVEEDORES_INY.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="FACT_COSTOS_UT_RET.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="FACT_COSTOS_EOR_RET.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="FACT_INGRESOS_EOR_RET.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="FACT_INGRESOS_CLIENTES_RET.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="PROCESAR_CUBO_INY.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="PROCESAR_CUBO_RET.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="PROCESAR_DIM_PROY.dtsx" SSIS:EntryPoint="1" />
- <SSIS:Package SSIS:Name="FACT_CONC_DIARIA_ASE.dtsx" SSIS:EntryPoint="1" />
- </SSIS:Packages>
- <SSIS:ConnectionManagers>
- <SSIS:ConnectionManager SSIS:Name="ORION.conmgr" />
- <SSIS:ConnectionManager SSIS:Name="DWH_ME.conmgr" />
- <SSIS:ConnectionManager SSIS:Name="OLAP_CUBE.conmgr" />
- </SSIS:ConnectionManagers>
- <SSIS:DeploymentInfo>
- <SSIS:ProjectConnectionParameters>
- <SSIS:Parameter SSIS:Name="CM.ORION.ConnectByProxy">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.ORION.ConnectionString">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <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>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.ORION.ConnectUsingManagedIdentity">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.ORION.InitialCatalog">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">PRD_ORION</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.ORION.Password">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">1</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.ORION.RetainSameConnection">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.ORION.ServerName">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">192.168.98.207</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.ORION.UserName">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">ETL_DWH</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.DWH_ME.ConnectByProxy">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.DWH_ME.ConnectionString">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">Data Source=192.168.98.23;Initial Catalog=DEV_DWH_MERELEC;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.DWH_ME.ConnectUsingManagedIdentity">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.DWH_ME.InitialCatalog">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">DEV_DWH_MERELEC</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.DWH_ME.Password">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">1</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.DWH_ME.RetainSameConnection">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.DWH_ME.ServerName">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">192.168.98.23</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.DWH_ME.UserName">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.OLAP_CUBE.ConnectionString">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">Data Source=192.168.100.6;Initial Catalog=OLAP_MERCADOS;Provider=MSOLAP.8;Integrated Security=SSPI;Impersonation Level=Impersonate;Location=192.168.100.6;</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.OLAP_CUBE.InitialCatalog">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">OLAP_MERCADOS</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.OLAP_CUBE.Password">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">1</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.OLAP_CUBE.RetainSameConnection">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">false</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">3</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.OLAP_CUBE.ServerName">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Value">192.168.100.6</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- <SSIS:Parameter SSIS:Name="CM.OLAP_CUBE.UserName">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="CreationName">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="IncludeInDebugDump">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Required">0</SSIS:Property>
- <SSIS:Property SSIS:Name="Sensitive">0</SSIS:Property>
- <SSIS:Property SSIS:Name="DataType">18</SSIS:Property>
- </SSIS:Properties>
- </SSIS:Parameter>
- </SSIS:ProjectConnectionParameters>
- <SSIS:PackageInfo>
- <SSIS:PackageMetaData SSIS:Name="DIM_AGENTES.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{16A2C4FF-0DA0-43A7-8D10-AB3AAE614551}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">DIM_AGENTES</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">74</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{6E2472E0-3007-4F0D-A3E4-A32439788974}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="DIM_PROYECTOS.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{94C87ECB-9F62-44AC-894A-7C2B6DC0C472}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">DIM_PROYECTOS</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">93</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{302020FA-0D45-402F-AA46-5D4E35D1A00F}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="FACT_INGRESOS_UT_INY.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{5C270E70-06F1-4F5A-87EB-F218B05F8F0A}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">FACT_INGRESOS_UT_INY</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">80</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{D02646B5-F92D-4084-B167-8483D2106919}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="FACT_COSTOS_UT_INY.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{C87D0BD3-5FD1-4EB9-B57A-3FB02541E3BC}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">FACT_COSTOS_UT_INY</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">39</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{928E045E-BBAE-449C-A0D7-8A5597C173F9}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="FACT_INGRESOS_EOR_INY.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{6262B267-CD6E-48AD-8CB8-18E89A2D7282}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">FACT_INGRESOS_EOR_INY</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">42</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{12896C74-5F25-4548-84B6-2C26B10F22BE}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="FACT_COSTOS_EOR_INY.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{74C3353E-B5F0-4164-848B-35FD46ABC789}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">FACT_COSTOS_EOR_INY</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">41</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{5BD95A5C-F449-418F-90D7-041650870501}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="FACT_COSTOS_PROVEEDORES_INY.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{0E35BB1C-81EE-439C-A707-977E03A3D54C}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">FACT_COSTOS_PROVEEDORES_INY</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">25</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{1D1AF8BA-CF87-48DA-92C5-2A90DA5BC3A8}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="FACT_COSTOS_UT_RET.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{A0F6C4B8-A071-409D-B4D1-0A86815839C0}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">FACT_COSTOS_UT_RET</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">28</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{F0B46EFC-A6DA-4267-9798-B3EB7BC6A9ED}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="FACT_COSTOS_EOR_RET.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{DFF2E171-1C03-4CAD-8101-1A71278F4848}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">FACT_COSTOS_EOR_RET</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">52</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{126A3B01-CBFC-4E64-8FB7-65D3C00016D7}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="FACT_INGRESOS_EOR_RET.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{F7512355-CA0C-4528-A79E-9920126B29B4}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">Package1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">18</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{6E753336-F691-4365-AAD4-F592251CC89E}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="FACT_INGRESOS_CLIENTES_RET.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{FEFD5E75-14EF-4845-9794-2DD9DD2801AC}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">FACT_INGRESOS_CLIENTES_RET</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">13</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{E89EC7D8-CDC6-4F9F-B872-DF5DBFDAA0D0}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="PROCESAR_CUBO_INY.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{48D03F4F-E636-4F90-A495-1F1F3B77D7C4}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">PROCESAR_CUBO_INY</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">7</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{2973D38E-1EF8-48DE-9188-B389F10CF424}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="PROCESAR_CUBO_RET.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{EDC2B0EC-24ED-4177-9614-0E768A55383E}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">PROCESAR_CUBO_RET</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">9</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{577DBCA9-0C09-4392-9069-F202F32B29B3}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="PROCESAR_DIM_PROY.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{A01414A6-ADB4-4F91-B937-9076ADFE4786}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">PROCESAR_DIM_PROY</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{F0383E1F-F2D8-4D06-9694-6B6F3D3AFC18}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- <SSIS:PackageMetaData SSIS:Name="FACT_CONC_DIARIA_ASE.dtsx">
- <SSIS:Properties>
- <SSIS:Property SSIS:Name="ID">{FFBC9455-B08A-4997-AA7D-329F6E016208}</SSIS:Property>
- <SSIS:Property SSIS:Name="Name">FACT_CONC_DIARIA_ASE</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMajor">1</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionMinor">0</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionBuild">16</SSIS:Property>
- <SSIS:Property SSIS:Name="VersionComments">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="VersionGUID">{79D3DCEF-9447-4C81-9718-B360FCAFDFBB}</SSIS:Property>
- <SSIS:Property SSIS:Name="PackageFormatVersion">8</SSIS:Property>
- <SSIS:Property SSIS:Name="Description">
- </SSIS:Property>
- <SSIS:Property SSIS:Name="ProtectionLevel">1</SSIS:Property>
- </SSIS:Properties>
- <SSIS:Parameters />
- </SSIS:PackageMetaData>
- </SSIS:PackageInfo>
- </SSIS:DeploymentInfo>
- </SSIS:Project>
- </Manifest>
- </DeploymentModelSpecificContent>
- <ControlFlowParts />
- <Miscellaneous />
- <Configurations>
- <Configuration>
- <Name>Development</Name>
- <Options>
- <OutputPath>bin</OutputPath>
- <ConnectionMappings />
- <ConnectionProviderMappings />
- <ConnectionSecurityMappings />
- <DatabaseStorageLocations />
- <TargetServerVersion>SQLServer2017</TargetServerVersion>
- <ParameterConfigurationValues>
- <ConfigurationSetting>
- <Id>LastModifiedTime</Id>
- <Name>LastModifiedTime</Name>
- <Value xsi:type="xsd:dateTime">2019-05-13T19:59:42.2251468Z</Value>
- </ConfigurationSetting>
- </ParameterConfigurationValues>
- </Options>
- </Configuration>
- </Configurations>
- </Project>
|