{"id":453,"date":"2015-03-20T04:36:37","date_gmt":"2015-03-20T04:36:37","guid":{"rendered":"http:\/\/arunethan.com\/?p=453"},"modified":"2015-12-01T16:25:15","modified_gmt":"2015-12-01T16:25:15","slug":"sql-server-integration-services-introduction","status":"publish","type":"post","link":"http:\/\/arunethan.com\/?p=453","title":{"rendered":"SQL Server Integration Services &#8211; Introduction"},"content":{"rendered":"<div class=\"pf-content\"><p>In SQL Server 2008<strong> Business Intelligence Studio<\/strong> is used to create the SSIS packages (Programs). It is the client side application. In SQL Server 2012 SQL Server<strong> data tools<\/strong> can be used to create SSIS projects.<\/p>\n<p><strong>Deployment<\/strong> are manifest of files, which is created in the developers computer and sent to the production environment or other computers.<\/p>\n<p>Package deployment can be done in the 1. command line 2. SQL Server 3. SQL Agent<\/p>\n<p>Command Line dtexec cmd can be used<\/p>\n<p>Ex:<\/p>\n<p><a href=\"http:\/\/arunethan.com\/wp-content\/uploads\/2015\/03\/Capture2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-466\" src=\"http:\/\/arunethan.com\/wp-content\/uploads\/2015\/03\/Capture2.png\" alt=\"Capture\" width=\"571\" height=\"53\" srcset=\"http:\/\/arunethan.com\/wp-content\/uploads\/2015\/03\/Capture2.png 571w, http:\/\/arunethan.com\/wp-content\/uploads\/2015\/03\/Capture2-300x27.png 300w\" sizes=\"(max-width: 571px) 100vw, 571px\" \/><\/a><\/p>\n<p><strong>Design Tab<\/strong><\/p>\n<p><a href=\"http:\/\/arunethan.com\/wp-content\/uploads\/2015\/03\/Capture1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-459\" src=\"http:\/\/arunethan.com\/wp-content\/uploads\/2015\/03\/Capture1-1024x675.png\" alt=\"Capture\" width=\"720\" height=\"474\" srcset=\"http:\/\/arunethan.com\/wp-content\/uploads\/2015\/03\/Capture1-1024x675.png 1024w, http:\/\/arunethan.com\/wp-content\/uploads\/2015\/03\/Capture1-300x197.png 300w, http:\/\/arunethan.com\/wp-content\/uploads\/2015\/03\/Capture1.png 1355w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><\/a><\/p>\n<p>The major sections of the <strong>Design tab<\/strong> of Data tools are<\/p>\n<p>1. Control Flow<\/p>\n<p>2. Data Flow<\/p>\n<p>3. Event Flow<\/p>\n<p>4. Package Explorer<\/p>\n<p>5. Connection Manager<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Control flow<\/strong> is procedure or the flow in which a package is executed. It need not be a linear execution. Control flow is made of task and\/or containers.<\/p>\n<p><strong>Data flow\u00a0<\/strong>is encapsulation of the data flowing between the source and destination. Within this en-capsule the data can be transformed, cleaned and modified.<\/p>\n<p>&nbsp;<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>In SQL Server 2008 Business Intelligence Studio is used to create the SSIS packages (Programs). It is the client side application. In SQL Server 2012 SQL Server data tools can be used to create&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":454,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[105],"tags":[76,73],"_links":{"self":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/453"}],"collection":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=453"}],"version-history":[{"count":9,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/453\/revisions"}],"predecessor-version":[{"id":467,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/453\/revisions\/467"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/media\/454"}],"wp:attachment":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=453"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}