{"id":11345,"date":"2024-03-08T07:44:26","date_gmt":"2024-03-08T06:44:26","guid":{"rendered":"https:\/\/expert-only.com\/?p=11345"},"modified":"2024-03-08T18:30:41","modified_gmt":"2024-03-08T17:30:41","slug":"how-to-connect-to-a-sql-server-database-using-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/","title":{"rendered":"How to Connect to a SQL Server Database using SSIS ?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\" id=\"h-step-by-step-tutorial-on-how-to-connect-to-a-sql-server-database-using-the-ssis-connection-manager-to-import-or-export-data\"><em>Step by step tutorial on how to connect to a SQL Server database using the SSIS connection manager to import or export data.<\/em><\/h4>\n\n\n\n<p>Tutorial on how to connect to a SQL Server database using the SSIS connection manager. To connect to a SQL database from an SSIS package, it is necessary and recommended to use the SSIS Connection Manager. It is also possible to use variables to manage connections strings, but it is an advanced topic and it will be covered in another tutorial. There are different types of connections available, like OLE DB, Flat file, ADO, Analysis Services, etc. <\/p>\n\n\n\n<p>Here is a short, step-by-step tutorial for creating a connection to an MS SQL database from an SSIS package. A connection manager can be used by multiple sources and destinations within a package. And also by multiple packages in a project if it is saved at the project level. <\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#1-first-create-an-ssis-project\" >1. First create an SSIS project<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#2-connect-to-sql-server-with-the-ssis-connection-manager\" >2. Connect to SQL Server with the SSIS Connection Manager<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#3-set-up-the-database-connection-in-the-package\" >3. Set up the database connection in the package<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#4-test-the-connectivity-to-the-sql-database\" >4. Test the connectivity to the SQL database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#5-video-tutorial-to-create-a-sql-connection-with-ssis\" >5. Video tutorial to create a SQL connection with SSIS<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-first-create-an-ssis-project\"><\/span>1. First create an SSIS project<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>First of all, the previous tutorial explains <a href=\"https:\/\/expert-only.com\/en\/ssis\/create-ssis-project-visual-studio-2019\/\">how to create a SSIS project step by step with Visual Studio 2019<\/a> and add a new package, i.e. a file in dtsx format.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"VcUwzONpVc\"><a href=\"https:\/\/expert-only.com\/en\/ssis\/create-ssis-project-visual-studio-2019\/\">How to create a new SSIS project with Visual Studio?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;How to create a new SSIS project with Visual Studio?&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/ssis\/create-ssis-project-visual-studio-2019\/embed\/#?secret=xdbgh5Abkc#?secret=VcUwzONpVc\" data-secret=\"VcUwzONpVc\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-connect-to-sql-server-with-the-ssis-connection-manager\"><\/span>2. Connect to SQL Server with the SSIS Connection Manager<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>First, use the Connection Managers area that is open by default when the SSIS package is opened. This area is located at the bottom of the screen in Visual Studio. It is possible to create different connection types for heterogeneous data sources, as below.<\/p>\n\n\n\n<p>In this case, it is New OLE DB Connection to create a connection with the recommended driver for direct connections to SQL Server databases. To create a connection to a SQL Server database in SSIS, follow these steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open an SSIS package from the Solution Explorer<\/li>\n\n\n\n<li>Right-click in the Connection Managers area<\/li>\n\n\n\n<li>Select New OLE DB Connection.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"724\" height=\"446\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/new-ole-db-connection-managers-ssis.jpg\" alt=\"Create a new OLE DB Connection using the SSIS Connection Manager\" class=\"wp-image-11320\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/new-ole-db-connection-managers-ssis.jpg 724w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/new-ole-db-connection-managers-ssis-300x185.jpg 300w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><figcaption class=\"wp-element-caption\">Create a new OLE DB Connection using the SSIS Connection Manager<\/figcaption><\/figure><\/div>\n\n\n<p>On the configuration screen, then select New :<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"590\" height=\"513\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/add-new-data-connection-ole-db-connection-manager.jpg\" alt=\"Add an OLA DB connection with the SSIS Connection Manager\" class=\"wp-image-11325\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/add-new-data-connection-ole-db-connection-manager.jpg 590w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/add-new-data-connection-ole-db-connection-manager-300x261.jpg 300w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><figcaption class=\"wp-element-caption\">Add an OLA DB connection with the SSIS Connection Manager<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-set-up-the-database-connection-in-the-package\"><\/span>3. Set up the database connection in the package<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Secondly, at this point you only need to fill in the SQL database connection options.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Enter the name of the database server, localhost in the example<\/li>\n\n\n\n<li>The authentication type, here it is Windows Authentication<\/li>\n\n\n\n<li>And choose the database, Expert-Only<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"712\" height=\"645\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/configure-ole-db-connection-server-and-database-in-ssis.jpg\" alt=\"How to connect to a SQL Server database with SSIS ?\" class=\"wp-image-11330\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/configure-ole-db-connection-server-and-database-in-ssis.jpg 712w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/configure-ole-db-connection-server-and-database-in-ssis-300x272.jpg 300w\" sizes=\"auto, (max-width: 712px) 100vw, 712px\" \/><figcaption class=\"wp-element-caption\"><strong>How to connect to a SQL Server database with SSIS ?<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>If you need <a href=\"https:\/\/expert-only.com\/en\/sql-server-db\/create-database-ssms\/\">to create an MS SQL database<\/a> first, then make sure you double check the connection details to avoid connection errors in the process. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-test-the-connectivity-to-the-sql-database\"><\/span>4. Test the connectivity to the SQL database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Then test the connection to verify connectivity. It is highly recommended to test the connection to avoid errors later in the package development.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"709\" height=\"160\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-test-connection-manager.jpg\" alt=\"Connect successfully to the SQL Server database from SSIS\" class=\"wp-image-11352\" style=\"width:709px;height:160px\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-test-connection-manager.jpg 709w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-test-connection-manager-300x68.jpg 300w\" sizes=\"auto, (max-width: 709px) 100vw, 709px\" \/><figcaption class=\"wp-element-caption\"><strong>Connect successfully to the SQL Server database from SSIS<\/strong><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-video-tutorial-to-create-a-sql-connection-with-ssis\"><\/span>5. Video tutorial to create a SQL connection with SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>A usual for the new tutorials, it is available in video format with all the steps illustrated with Visual Studio 2019. <\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"How to create SSIS projects and packages with Visual Studio?\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/kiFfsMRtk48?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><figcaption class=\"wp-element-caption\"><em>Youtube video on how to create a connection to a SQL Server database inside an SSIS package.<\/em><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-about-integration-services-connectivity-to-sql-server-databases\">About Integration Services connectivity to SQL Server databases<\/h3>\n\n\n\n<p>The logical next step is to create a simple data stream within the <a href=\"https:\/\/en.wikipedia.org\/wiki\/SQL_Server_Integration_Services\" target=\"_blank\" rel=\"noreferrer noopener\">SSIS<\/a> control flow. In general, the purpose of an ETL package is to transfer and eventually transform data from a source to a target. Here another tutorial to solve a typical Excel data integration issue with SSIS, i.e., <a href=\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/\">how to manage Excel data type within a package<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"FeKFdeo3O3\"><a href=\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/\">Manage Excel data type with SSIS before integration<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Manage Excel data type with SSIS before integration&#8221; &#8212; SQL and IT Tutorials\" src=\"https:\/\/expert-only.com\/en\/ssis\/manage-excel-data-type-ssis\/embed\/#?secret=dQCGuaYrVb#?secret=FeKFdeo3O3\" data-secret=\"FeKFdeo3O3\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Step by step tutorial on how to connect to a SQL Server database using the SSIS connection manager to import or export data. Tutorial on how to connect to a SQL Server database using the SSIS connection manager. To <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/\" title=\"How to Connect to a SQL Server Database using SSIS ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10799,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[516],"tags":[],"class_list":{"0":"post-11345","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssis"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Connect to a SQL Server Database using SSIS ? MS BI<\/title>\n<meta name=\"description\" content=\"How to connect to a SQL Server database with SSIS ? Create a dedicated Connection Manager in the package using the Connection Manager.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Connect to a SQL Server Database using SSIS ?\" \/>\n<meta property=\"og:description\" content=\"How to connect to a SQL Server database with SSIS ? Create a dedicated Connection Manager in the package using the Connection Manager.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-08T06:44:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-08T17:30:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"How to Connect to a SQL Server Database using SSIS ?\",\"datePublished\":\"2024-03-08T06:44:26+00:00\",\"dateModified\":\"2024-03-08T17:30:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/\"},\"wordCount\":586,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/\",\"url\":\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/\",\"name\":\"How to Connect to a SQL Server Database using SSIS ? MS BI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg\",\"datePublished\":\"2024-03-08T06:44:26+00:00\",\"dateModified\":\"2024-03-08T17:30:41+00:00\",\"description\":\"How to connect to a SQL Server database with SSIS ? Create a dedicated Connection Manager in the package using the Connection Manager.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Connect to a SQL Server Database using SSIS ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Connect to a SQL Server Database using SSIS ? MS BI","description":"How to connect to a SQL Server database with SSIS ? Create a dedicated Connection Manager in the package using the Connection Manager.","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:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/","og_locale":"en_US","og_type":"article","og_title":"How to Connect to a SQL Server Database using SSIS ?","og_description":"How to connect to a SQL Server database with SSIS ? Create a dedicated Connection Manager in the package using the Connection Manager.","og_url":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-08T06:44:26+00:00","article_modified_time":"2024-03-08T17:30:41+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"How to Connect to a SQL Server Database using SSIS ?","datePublished":"2024-03-08T06:44:26+00:00","dateModified":"2024-03-08T17:30:41+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/"},"wordCount":586,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/","url":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/","name":"How to Connect to a SQL Server Database using SSIS ? MS BI","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg","datePublished":"2024-03-08T06:44:26+00:00","dateModified":"2024-03-08T17:30:41+00:00","description":"How to connect to a SQL Server database with SSIS ? Create a dedicated Connection Manager in the package using the Connection Manager.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to Connect to a SQL Server Database using SSIS ?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/11345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=11345"}],"version-history":[{"count":1,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/11345\/revisions"}],"predecessor-version":[{"id":30596,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/11345\/revisions\/30596"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/10799"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=11345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=11345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=11345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}