{"id":1199,"date":"2016-12-24T18:56:08","date_gmt":"2016-12-24T13:26:08","guid":{"rendered":"http:\/\/stepbystepschools.net\/?p=1199"},"modified":"2016-12-24T18:56:44","modified_gmt":"2016-12-24T13:26:44","slug":"learning-ssis-solution-structure-in-msbi","status":"publish","type":"post","link":"https:\/\/www.stepbystepschools.net\/?p=1199","title":{"rendered":"Learning SSIS Solution Structure in MSBI"},"content":{"rendered":"<p><a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">MSBI Mumbai training<\/a> session on fundamental and important concept which has to be understood by every learner. Here are the brief discussion down below.<\/p>\n<p>Solution structure of a SSIS project: &#8211;<\/p>\n<ul>\n<li>The solution structure is as follows, in a solution there is a project and inside a project there are dtsx files and parameters.<\/li>\n<li>Now a solution can contain many projects and a project can contain many dtsx files.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-5.jpg\" rel=\"attachment wp-att-1201\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-1201\" src=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-5.jpg\" alt=\"1\" width=\"628\" height=\"381\" srcset=\"https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-5.jpg 628w, https:\/\/www.stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-5-300x182.jpg 300w\" sizes=\"(max-width: 628px) 100vw, 628px\" \/><\/a><\/p>\n<ul>\n<li>What are the 2 ways of deploying SSIS project?<\/li>\n<\/ul>\n<ol>\n<li>Project Deployment<\/li>\n<li>Package Deployment<\/li>\n<\/ol>\n<p>What is Difference between Project deployment &amp; Package deployment?<\/p>\n<p>Project Deployment:<\/p>\n<ul>\n<li>In project deployment the whole project can be deployed in one go.<\/li>\n<li>This deployment method has been introduced from 2012 and is the most preferred way of deploying the SSIS project.<\/li>\n<li>By this deployment method we can deploy the project in our SQL Server, MSDB, File System.<\/li>\n<\/ul>\n<p>Package Deployment:<\/p>\n<ul>\n<li>In Package deployment the packages which are present in a project can be deployed individually.<\/li>\n<li>This deployment method was active till 2008. It was mainly used when after the deployment of project was done there were some packages which were modified later and they had to be deployed, so individual packages were deployed.<\/li>\n<li>By this deployment method we can deploy packages only and only in MSDB &amp; File System. We cannot deploy the packages in our SQL Server.<\/li>\n<\/ul>\n<p>We understand theories are boring but our training experts makes them easy and interesting. Also personal attention is given during<br \/>\n<a href=\"http:\/\/www.learnmsbitutorials.net\/training.php\" target=\"_blank\">training of MSBI, Mumbai<\/a> to each candidate.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MSBI Mumbai training session on fundamental and important concept which has to be understood by every learner. Here are the brief discussion down below. Solution structure of a SSIS project: &#8211; The solution structure is as follows, in a solution &hellip; <a href=\"https:\/\/www.stepbystepschools.net\/?p=1199\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[106],"tags":[121,112,111,109,108,123,120],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Learning SSIS Solution Structure in MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stepbystepschools.net\/?p=1199\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learning SSIS Solution Structure in MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"og:description\" content=\"MSBI Mumbai training session on fundamental and important concept which has to be understood by every learner. Here are the brief discussion down below. Solution structure of a SSIS project: &#8211; The solution structure is as follows, in a solution &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stepbystepschools.net\/?p=1199\" \/>\n<meta property=\"og:site_name\" content=\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-24T13:26:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-12-24T13:26:44+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-5.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"StepByStepSchoolsSupport\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\",\"url\":\"https:\/\/www.stepbystepschools.net\/\",\"name\":\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"description\":\"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stepbystepschools.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1199#primaryimage\",\"url\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-5.jpg\",\"contentUrl\":\"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-5.jpg\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1199#webpage\",\"url\":\"https:\/\/www.stepbystepschools.net\/?p=1199\",\"name\":\"Learning SSIS Solution Structure in MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"isPartOf\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1199#primaryimage\"},\"datePublished\":\"2016-12-24T13:26:08+00:00\",\"dateModified\":\"2016-12-24T13:26:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1199#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stepbystepschools.net\/?p=1199\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?p=1199#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stepbystepschools.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learning SSIS Solution Structure in MSBI\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655\",\"name\":\"StepByStepSchoolsSupport\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g\",\"caption\":\"StepByStepSchoolsSupport\"},\"url\":\"https:\/\/www.stepbystepschools.net\/?author=40\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learning SSIS Solution Structure in MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stepbystepschools.net\/?p=1199","og_locale":"en_US","og_type":"article","og_title":"Learning SSIS Solution Structure in MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","og_description":"MSBI Mumbai training session on fundamental and important concept which has to be understood by every learner. Here are the brief discussion down below. Solution structure of a SSIS project: &#8211; The solution structure is as follows, in a solution &hellip; Continue reading &rarr;","og_url":"https:\/\/www.stepbystepschools.net\/?p=1199","og_site_name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","article_published_time":"2016-12-24T13:26:08+00:00","article_modified_time":"2016-12-24T13:26:44+00:00","og_image":[{"url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-5.jpg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"StepByStepSchoolsSupport","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.stepbystepschools.net\/#website","url":"https:\/\/www.stepbystepschools.net\/","name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","description":"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stepbystepschools.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stepbystepschools.net\/?p=1199#primaryimage","url":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-5.jpg","contentUrl":"http:\/\/stepbystepschools.net\/wp-content\/uploads\/2016\/12\/1-5.jpg"},{"@type":"WebPage","@id":"https:\/\/www.stepbystepschools.net\/?p=1199#webpage","url":"https:\/\/www.stepbystepschools.net\/?p=1199","name":"Learning SSIS Solution Structure in MSBI - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","isPartOf":{"@id":"https:\/\/www.stepbystepschools.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1199#primaryimage"},"datePublished":"2016-12-24T13:26:08+00:00","dateModified":"2016-12-24T13:26:44+00:00","author":{"@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655"},"breadcrumb":{"@id":"https:\/\/www.stepbystepschools.net\/?p=1199#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stepbystepschools.net\/?p=1199"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.stepbystepschools.net\/?p=1199#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stepbystepschools.net\/"},{"@type":"ListItem","position":2,"name":"Learning SSIS Solution Structure in MSBI"}]},{"@type":"Person","@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/7131e4ee1c5673879e6029d14ec2f655","name":"StepByStepSchoolsSupport","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stepbystepschools.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cecaf2a0ee369391127b0159c266979d?s=96&d=mm&r=g","caption":"StepByStepSchoolsSupport"},"url":"https:\/\/www.stepbystepschools.net\/?author=40"}]}},"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1199"}],"collection":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1199"}],"version-history":[{"count":1,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1199\/revisions"}],"predecessor-version":[{"id":1202,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/posts\/1199\/revisions\/1202"}],"wp:attachment":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}