{"id":3610,"date":"2018-09-05T23:03:49","date_gmt":"2018-09-05T23:03:49","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=3610"},"modified":"2018-09-05T23:03:49","modified_gmt":"2018-09-05T23:03:49","slug":"how-to-open-dstx-files-from-sql-server","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server","title":{"rendered":"How to open .DSTX Files from SQL Server"},"content":{"rendered":"<p>So you&#8217;ve found an issue in a Package in a Project for a DataSynchronization\u00a0in a Integration Services Catalogs ( .dtsx file ) that you want to edit?<\/p><p id=\"stIbKaN\"><img loading=\"lazy\" decoding=\"async\" width=\"262\" height=\"162\" class=\"alignnone size-full wp-image-3611  img-responsive\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b905ef4ea3ef.png\" alt=\"\" \/><\/p><p>Install if its not already on it and open SQL Server Data Tools<\/p><p id=\"iZXtseN\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"61\" class=\"alignnone size-full wp-image-3612  img-responsive\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b905f62e2c1d.png\" alt=\"\" \/><\/p><p>Click on File and New Project<\/p><p>Choose this Project<\/p><p id=\"QBzaEpI\"><img loading=\"lazy\" decoding=\"async\" width=\"811\" height=\"254\" class=\"alignnone size-full wp-image-3613  img-responsive\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b905f96e82d0.png\" alt=\"\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b905f96e82d0.png 811w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b905f96e82d0-300x94.png 300w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b905f96e82d0-768x241.png 768w\" sizes=\"auto, (max-width: 811px) 100vw, 811px\" \/><\/p><p>Choose &#8220;Intergration Servies Catalog&#8221; and Open the project<\/p><p id=\"fQxrwmO\"><img loading=\"lazy\" decoding=\"async\" width=\"664\" height=\"229\" class=\"alignnone size-full wp-image-3614  img-responsive\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b905fcfa94be.png\" alt=\"\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b905fcfa94be.png 664w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b905fcfa94be-300x103.png 300w\" sizes=\"auto, (max-width: 664px) 100vw, 664px\" \/><\/p><p>You should see the .dstx files on the right under<\/p><p id=\"PrUxUsY\"><img loading=\"lazy\" decoding=\"async\" width=\"222\" height=\"31\" class=\"alignnone size-full wp-image-3615  img-responsive\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b9060c89db10.png\" alt=\"\" \/><\/p>","protected":false},"excerpt":{"rendered":"<p>So you&#8217;ve found an issue in a Package in a Project for a DataSynchronization\u00a0in a Integration Services Catalogs ( .dtsx file ) that you want to edit?Install [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[2650,2651,2652,591,2653],"class_list":["post-3610","post","type-post","status-publish","format-standard","hentry","category-random","tag-dtsx","tag-datasynchronization","tag-integration-services-catalogs","tag-sql","tag-ssidb"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"So you&#039;ve found an issue in a Package in a Project for a DataSynchronization in a Integration Services Catalogs ( .dtsx file ) that you want to edit?Install if its not already on it and open SQL Server Data ToolsClick on File and New ProjectChoose this ProjectChoose &quot;Intergration Servies Catalog&quot; and Open the projectYou should see\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"paris\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Welcome to Pariswells.com |\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"How to open .DSTX Files from SQL Server | Welcome to Pariswells.com\" \/>\n\t\t<meta property=\"og:description\" content=\"So you&#039;ve found an issue in a Package in a Project for a DataSynchronization in a Integration Services Catalogs ( .dtsx file ) that you want to edit?Install if its not already on it and open SQL Server Data ToolsClick on File and New ProjectChoose this ProjectChoose &quot;Intergration Servies Catalog&quot; and Open the projectYou should see\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2018-09-05T23:03:49+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2018-09-05T23:03:49+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"How to open .DSTX Files from SQL Server | Welcome to Pariswells.com\" \/>\n\t\t<meta name=\"twitter:description\" content=\"So you&#039;ve found an issue in a Package in a Project for a DataSynchronization in a Integration Services Catalogs ( .dtsx file ) that you want to edit?Install if its not already on it and open SQL Server Data ToolsClick on File and New ProjectChoose this ProjectChoose &quot;Intergration Servies Catalog&quot; and Open the projectYou should see\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/random\\\/how-to-open-dstx-files-from-sql-server#article\",\"name\":\"How to open .DSTX Files from SQL Server | Welcome to Pariswells.com\",\"headline\":\"How to open .DSTX Files from SQL Server\",\"author\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/09\\\/img_5b905ef4ea3ef.png\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/random\\\/how-to-open-dstx-files-from-sql-server\\\/#articleImage\",\"width\":262,\"height\":162},\"datePublished\":\"2018-09-05T23:03:49+00:00\",\"dateModified\":\"2018-09-05T23:03:49+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/random\\\/how-to-open-dstx-files-from-sql-server#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/random\\\/how-to-open-dstx-files-from-sql-server#webpage\"},\"articleSection\":\"Random, .dtsx, DataSynchronization, Integration Services Catalogs, SQL, SSIDB\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/random\\\/how-to-open-dstx-files-from-sql-server#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pariswells.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/random#listItem\",\"name\":\"Random\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/random#listItem\",\"position\":2,\"name\":\"Random\",\"item\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/random\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/random\\\/how-to-open-dstx-files-from-sql-server#listItem\",\"name\":\"How to open .DSTX Files from SQL Server\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/random\\\/how-to-open-dstx-files-from-sql-server#listItem\",\"position\":3,\"name\":\"How to open .DSTX Files from SQL Server\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/category\\\/random#listItem\",\"name\":\"Random\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#organization\",\"name\":\"Welcome to Pariswells.com\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris\",\"name\":\"paris\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/random\\\/how-to-open-dstx-files-from-sql-server#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/93b8ee3f592ac401167f870452bd82d43de80152cd3524e2853403658ada9984?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"paris\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/random\\\/how-to-open-dstx-files-from-sql-server#webpage\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/random\\\/how-to-open-dstx-files-from-sql-server\",\"name\":\"How to open .DSTX Files from SQL Server | Welcome to Pariswells.com\",\"description\":\"So you've found an issue in a Package in a Project for a DataSynchronization in a Integration Services Catalogs ( .dtsx file ) that you want to edit?Install if its not already on it and open SQL Server Data ToolsClick on File and New ProjectChoose this ProjectChoose \\\"Intergration Servies Catalog\\\" and Open the projectYou should see\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/random\\\/how-to-open-dstx-files-from-sql-server#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/author\\\/paris#author\"},\"datePublished\":\"2018-09-05T23:03:49+00:00\",\"dateModified\":\"2018-09-05T23:03:49+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/\",\"name\":\"Welcome to Pariswells.com\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/pariswells.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to open .DSTX Files from SQL Server | Welcome to Pariswells.com","description":"So you've found an issue in a Package in a Project for a DataSynchronization in a Integration Services Catalogs ( .dtsx file ) that you want to edit?Install if its not already on it and open SQL Server Data ToolsClick on File and New ProjectChoose this ProjectChoose \"Intergration Servies Catalog\" and Open the projectYou should see","canonical_url":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server#article","name":"How to open .DSTX Files from SQL Server | Welcome to Pariswells.com","headline":"How to open .DSTX Files from SQL Server","author":{"@id":"https:\/\/pariswells.com\/blog\/author\/paris#author"},"publisher":{"@id":"https:\/\/pariswells.com\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/09\/img_5b905ef4ea3ef.png","@id":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server\/#articleImage","width":262,"height":162},"datePublished":"2018-09-05T23:03:49+00:00","dateModified":"2018-09-05T23:03:49+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server#webpage"},"isPartOf":{"@id":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server#webpage"},"articleSection":"Random, .dtsx, DataSynchronization, Integration Services Catalogs, SQL, SSIDB"},{"@type":"BreadcrumbList","@id":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/pariswells.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/category\/random#listItem","name":"Random"}},{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/category\/random#listItem","position":2,"name":"Random","item":"https:\/\/pariswells.com\/blog\/category\/random","nextItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server#listItem","name":"How to open .DSTX Files from SQL Server"},"previousItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server#listItem","position":3,"name":"How to open .DSTX Files from SQL Server","previousItem":{"@type":"ListItem","@id":"https:\/\/pariswells.com\/blog\/category\/random#listItem","name":"Random"}}]},{"@type":"Organization","@id":"https:\/\/pariswells.com\/blog\/#organization","name":"Welcome to Pariswells.com","url":"https:\/\/pariswells.com\/blog\/"},{"@type":"Person","@id":"https:\/\/pariswells.com\/blog\/author\/paris#author","url":"https:\/\/pariswells.com\/blog\/author\/paris","name":"paris","image":{"@type":"ImageObject","@id":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/93b8ee3f592ac401167f870452bd82d43de80152cd3524e2853403658ada9984?s=96&d=mm&r=g","width":96,"height":96,"caption":"paris"}},{"@type":"WebPage","@id":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server#webpage","url":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server","name":"How to open .DSTX Files from SQL Server | Welcome to Pariswells.com","description":"So you've found an issue in a Package in a Project for a DataSynchronization in a Integration Services Catalogs ( .dtsx file ) that you want to edit?Install if its not already on it and open SQL Server Data ToolsClick on File and New ProjectChoose this ProjectChoose \"Intergration Servies Catalog\" and Open the projectYou should see","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/pariswells.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server#breadcrumblist"},"author":{"@id":"https:\/\/pariswells.com\/blog\/author\/paris#author"},"creator":{"@id":"https:\/\/pariswells.com\/blog\/author\/paris#author"},"datePublished":"2018-09-05T23:03:49+00:00","dateModified":"2018-09-05T23:03:49+00:00"},{"@type":"WebSite","@id":"https:\/\/pariswells.com\/blog\/#website","url":"https:\/\/pariswells.com\/blog\/","name":"Welcome to Pariswells.com","inLanguage":"en-US","publisher":{"@id":"https:\/\/pariswells.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Welcome to Pariswells.com |","og:type":"article","og:title":"How to open .DSTX Files from SQL Server | Welcome to Pariswells.com","og:description":"So you've found an issue in a Package in a Project for a DataSynchronization in a Integration Services Catalogs ( .dtsx file ) that you want to edit?Install if its not already on it and open SQL Server Data ToolsClick on File and New ProjectChoose this ProjectChoose &quot;Intergration Servies Catalog&quot; and Open the projectYou should see","og:url":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server","article:published_time":"2018-09-05T23:03:49+00:00","article:modified_time":"2018-09-05T23:03:49+00:00","twitter:card":"summary","twitter:title":"How to open .DSTX Files from SQL Server | Welcome to Pariswells.com","twitter:description":"So you've found an issue in a Package in a Project for a DataSynchronization in a Integration Services Catalogs ( .dtsx file ) that you want to edit?Install if its not already on it and open SQL Server Data ToolsClick on File and New ProjectChoose this ProjectChoose &quot;Intergration Servies Catalog&quot; and Open the projectYou should see"},"aioseo_meta_data":{"post_id":"3610","title":null,"description":null,"keywords":null,"keyphrases":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 05:33:27","updated":"2022-09-19 06:40:34","primary_term":null,"seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/pariswells.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/pariswells.com\/blog\/category\/random\" title=\"Random\">Random<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to open .DSTX Files from SQL Server\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/pariswells.com\/blog"},{"label":"Random","link":"https:\/\/pariswells.com\/blog\/category\/random"},{"label":"How to open .DSTX Files from SQL Server","link":"https:\/\/pariswells.com\/blog\/random\/how-to-open-dstx-files-from-sql-server"}],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=3610"}],"version-history":[{"count":1,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3610\/revisions"}],"predecessor-version":[{"id":3616,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3610\/revisions\/3616"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=3610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=3610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=3610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}