{"id":303,"date":"2023-01-21T14:16:06","date_gmt":"2023-01-21T13:16:06","guid":{"rendered":"https:\/\/pampadata.com\/?p=303"},"modified":"2023-10-08T14:16:45","modified_gmt":"2023-10-08T12:16:45","slug":"conocer-la-version-desplegada-de-un-paquete-ssis","status":"publish","type":"post","link":"https:\/\/pampadata.com\/en\/conocer-la-version-desplegada-de-un-paquete-ssis\/","title":{"rendered":"Conocer la Version desplegada de un paquete SSIS"},"content":{"rendered":"<p>Seguramente les ha pasado, sobretodo cuando trabajan con multiples entornos (DEV, TEST y PROD por ejemplo) que no recuerdan \u00bfC\u00faal versi\u00f3n de un determinado paquete esta desplegada? o \u00bfQui\u00e9n ha desplegado la \u00faltima versi\u00f3n? incluso \u00bfCu\u00e1ndo se ha desplegado esa \u00faltima versi\u00f3n del paquete SSIS?<\/p>\n\n\n\n<p>Esto es a\u00fan peor cuando trabajamos con alguna herramienta de versionado porque tendremos una enorme variedad de versiones para un mismo paquete e incluso muchos colabodores trabajando sobre el mismo.<\/p>\n\n\n\n<p>Para no volvernos locos y evitar confuciones es bueno que podamos chequear algunos datos sobre los paquete desplegados.<\/p>\n\n\n\n<p>Para esto podemos consultar dentro de la base SSIS la tabla \u201cinternal.packages\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"136\" src=\"https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-1024x136.png\" alt=\"\" class=\"wp-image-304\" srcset=\"https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-1024x136.png 1024w, https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-300x40.png 300w, https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-768x102.png 768w, https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-18x2.png 18w, https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image.png 1427w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Esta versi\u00f3n debe coincidir con la version que tengamos en nuestra soluci\u00f3n de Visual Studio.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"408\" height=\"692\" src=\"https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-1.png\" alt=\"\" class=\"wp-image-305\" srcset=\"https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-1.png 408w, https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-1-177x300.png 177w, https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-1-7x12.png 7w\" sizes=\"(max-width: 408px) 100vw, 408px\" \/><\/figure>\n\n\n\n<p>Adicionalmente, si lo que hacemos es despliegues enteros por proyectos, podriamos utilizar la tabla \u201cInternal.Projects\u201d para comprobar la fecha del \u00faltimo despliegue y la persona que lo realizo.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"109\" src=\"https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-2-1024x109.png\" alt=\"\" class=\"wp-image-306\" srcset=\"https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-2-1024x109.png 1024w, https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-2-300x32.png 300w, https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-2-768x82.png 768w, https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-2-18x2.png 18w, https:\/\/pampadata.com\/wp-content\/uploads\/2023\/10\/image-2.png 1480w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Por \u00faltimo aqui les compartimos una posible query utilizando las mencionadas tablas para rastrear un paquete en particular:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT DISTINCT\r\np.name as PackageName\r\n,p.version_build as VersionBuild\r\n,pr.name as ProjectName\r\n,pr.last_deployed_time as LastDeployedTime\r\n,pr.deployed_by_name as DeployedByName\r\nFROM internal.packages p\r\nINNER JOIN internal.projects pr\r\non pr.project_id = p.project_id\r\nWHERE p.NAME like \u2018%Customer%\u2019<\/code><\/pre>\n\n\n\n<p>Esperamos que esto les sea de \u00fatilidad para conocer las versiones desplegadas!<\/p>","protected":false},"excerpt":{"rendered":"<p>Seguramente les ha pasado, sobretodo cuando trabajan con multiples entornos (DEV, TEST y PROD por ejemplo) que no recuerdan \u00bfC\u00faal versi\u00f3n de un determinado paquete esta desplegada? o \u00bfQui\u00e9n ha desplegado la \u00faltima versi\u00f3n? incluso \u00bfCu\u00e1ndo se ha desplegado esa \u00faltima versi\u00f3n del paquete SSIS? Esto es a\u00fan peor cuando [&hellip;]<\/p>","protected":false},"author":1,"featured_media":307,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_ti_tpc_template_sync":false,"_ti_tpc_template_id":"","footnotes":""},"categories":[7,11],"tags":[],"class_list":["post-303","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft","category-ssis"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pampadata.com\/en\/wp-json\/wp\/v2\/posts\/303"}],"collection":[{"href":"https:\/\/pampadata.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pampadata.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pampadata.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pampadata.com\/en\/wp-json\/wp\/v2\/comments?post=303"}],"version-history":[{"count":1,"href":"https:\/\/pampadata.com\/en\/wp-json\/wp\/v2\/posts\/303\/revisions"}],"predecessor-version":[{"id":308,"href":"https:\/\/pampadata.com\/en\/wp-json\/wp\/v2\/posts\/303\/revisions\/308"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pampadata.com\/en\/wp-json\/wp\/v2\/media\/307"}],"wp:attachment":[{"href":"https:\/\/pampadata.com\/en\/wp-json\/wp\/v2\/media?parent=303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pampadata.com\/en\/wp-json\/wp\/v2\/categories?post=303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pampadata.com\/en\/wp-json\/wp\/v2\/tags?post=303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}