{"id":12021,"date":"2024-03-08T07:44:26","date_gmt":"2024-03-08T06:44:26","guid":{"rendered":"https:\/\/expert-only.com\/?p=12021"},"modified":"2022-12-07T10:22:47","modified_gmt":"2022-12-07T09:22:47","slug":"conexion-a-una-base-sql-server-con-ssis","status":"publish","type":"post","link":"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/","title":{"rendered":"Conexi\u00f3n a una base de SQL Server con SSIS"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\" id=\"h-como-crear-una-conexion-a-una-base-de-datos-de-sql-server-con-un-paquete-ssis\"><strong><em>\u00bfC\u00f3mo crear una conexi\u00f3n a una base de datos de SQL Server con un paquete SSIS?<\/em><\/strong><\/h4>\n\n\n\n<p>Para a\u00f1adir una conexi\u00f3n a una base de datos SQL Server con un paquete SSIS, para los principiantes es necesario y recomendable utilizar el gestor de conexiones. Tambi\u00e9n es posible utilizar variables para gestionar din\u00e1micamente las cadenas de conexi\u00f3n, pero este es un tema avanzado que se tratar\u00e1 en otro tutorial. Existen diferentes tipos de conexiones, como OLE DB, ODBC, Flat files, ADO, Analysis Services (OLAP), XML, Excel, Azure, FTP, HTTP, etc.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Crear una conexi\u00f3n SSIS a una origen de datos de SQL Server <\/h2>\n\n\n\n<p>Este tutorial explica, paso a paso, c\u00f3mo crear una conexi\u00f3n a una base de datos MS SQL desde un paquete de Integration Services, para importar o exportar desde la base de datos de origen a una de destino.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">El requisito es crear un proyecto SSIS con Visual Studio<\/h2>\n\n\n\n<p>En primer lugar, el tutorial anterior explica c\u00f3mo crear un proyecto SSIS paso a paso con Visual Studio 2019 y a\u00f1adir un nuevo paquete, es decir, un archivo en formato dtsx. Por lo tanto, tambi\u00e9n es necesario tener un entorno de desarrollo SSIS, es decir, <a href=\"https:\/\/expert-only.com\/es\/ssis\/instalar-proyectos-ssis-visual-studio-2019\/\">instalar visual studio 2019 con la extensi\u00f3n de los proyectos SSIS<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriales-de-sql-y-ti wp-block-embed-tutoriales-de-sql-y-ti\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"m9VvNdC32q\"><a href=\"https:\/\/expert-only.com\/es\/ssis\/instalar-proyectos-ssis-visual-studio-2019\/\">C\u00f3mo instalar los proyectos SSIS en Visual Studio 2019?<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00abC\u00f3mo instalar los proyectos SSIS en Visual Studio 2019?\u00bb \u2014 Tutoriales de SQL y TI\" src=\"https:\/\/expert-only.com\/es\/ssis\/instalar-proyectos-ssis-visual-studio-2019\/embed\/#?secret=SsVGx2oExc#?secret=m9VvNdC32q\" data-secret=\"m9VvNdC32q\" 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\">1. Crear una conexi\u00f3n con el Gestor de Conexiones SSIS<\/h2>\n\n\n\n<p>En primer lugar, utilice el \u00e1rea de gestores de conexi\u00f3n que se abre por defecto cuando se abre el paquete <a href=\"https:\/\/es.wikipedia.org\/wiki\/SQL_Server_Integration_Services\" target=\"_blank\" rel=\"noreferrer noopener\">SSIS o SQL Server Integration Services<\/a>. Esta \u00e1rea se encuentra en la parte inferior de la pantalla en Visual Studio 2019. Es posible crear diferentes tipos de conexiones para utilizar fuentes de datos heterog\u00e9neas, como se indica a continuaci\u00f3n. En este caso, se trata de <em>Nueva conexi\u00f3n OLE DB<\/em> para crear una conexi\u00f3n con el controlador recomendado para las conexiones directas a las bases de datos de SQL Server.<\/p>\n\n\n\n<p>Siga estos pasos:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Abra un paquete SSIS desde el Explorador de soluciones.<\/li>\n\n\n\n<li>Haga clic con el bot\u00f3n derecho del rat\u00f3n en el \u00e1rea de gestores de conexi\u00f3n.<\/li>\n\n\n\n<li>Seleccione Nueva conexi\u00f3n OLE DB.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/new-ole-db-connection-managers-ssis.jpg\" alt=\"Conexi\u00f3n a una base de SQL Server con SSIS y el administrador de conexiones\" class=\"wp-image-11322\" width=\"724\" height=\"446\" 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\"><strong>Conexi\u00f3n a una base de SQL Server con SSIS y el administrador de conexiones<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>En la pantalla de configuraci\u00f3n, seleccione <em>Nuevo<\/em> :<\/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=\"Configurar el nuevo gestor de conexiones ole db con SSIS\" class=\"wp-image-11327\" 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\">Configurar el nuevo gestor de conexiones ole db con SSIS<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">2. Configurar la conexi\u00f3n a la base de datos MS SQL<\/h2>\n\n\n\n<p>En segundo lugar, en este punto s\u00f3lo hay que rellenar las opciones de conexi\u00f3n a la base de datos SQL.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Seleccione el tipo de proveedor de datos: <em>Native OLE DB\\SQL Server Native Client 11.0<\/em>.<\/li>\n\n\n\n<li>Introduzca el nombre del servidor de la base de datos, <em>localhost<\/em> en el ejemplo, ya que se trata de una base de datos local. y elija el tipo de autenticaci\u00f3n, aqu\u00ed es <em>Autenticaci\u00f3n de Windows<\/em>.<\/li>\n\n\n\n<li>Y elige la base de datos, aqu\u00ed es <em>Expert-Only<\/em>.<\/li>\n\n\n\n<li>Probar la conexi\u00f3n con la base de datos.<\/li>\n\n\n\n<li>Validar.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/configure-ole-db-connection-server-and-database-in-ssis.jpg\" alt=\"Conexi\u00f3n a una base de datos de SQL Server con SSIS\" class=\"wp-image-11332\" width=\"712\" height=\"645\" 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>Conexi\u00f3n a una base de datos de SQL Server con SSIS<\/strong><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">3. Probar la conectividad con la base de datos<\/h2>\n\n\n\n<p>A continuaci\u00f3n, pruebe la conexi\u00f3n para verificar la conectividad. Se recomienda probar la conexi\u00f3n lo antes posible para evitar errores durante el desarrollo del paquete de Servicios de Integraci\u00f3n.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><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=\"Prueba de conexi\u00f3n con \u00e9xito a la fuente de datos SQL Server\" class=\"wp-image-11356\" 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>Prueba de conexi\u00f3n con \u00e9xito a la fuente de datos SQL Server<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>El siguiente paso l\u00f3gico es crear un flujo de datos sencillo dentro del flujo de control de SSIS. El objetivo de un paquete ETL es transferir y transformar los datos de una tabla de origen a una tabla de destino.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriales-de-sql-y-ti wp-block-embed-tutoriales-de-sql-y-ti\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"GYUmmn7Fqz\"><a href=\"https:\/\/expert-only.com\/es\/ssis\/crear-proyecto-ssis-con-visual-studio-2019\/\">\u00bfC\u00f3mo crear un proyecto SSIS y una soluci\u00f3n con 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=\"\u00ab\u00bfC\u00f3mo crear un proyecto SSIS y una soluci\u00f3n con Visual Studio?\u00bb \u2014 Tutoriales de SQL y TI\" src=\"https:\/\/expert-only.com\/es\/ssis\/crear-proyecto-ssis-con-visual-studio-2019\/embed\/#?secret=H9tDQvzuZz#?secret=GYUmmn7Fqz\" data-secret=\"GYUmmn7Fqz\" 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>\u00bfC\u00f3mo crear una conexi\u00f3n a una base de datos de SQL Server con un paquete SSIS? Para a\u00f1adir una conexi\u00f3n a una base de datos SQL Server con un paquete SSIS, para los principiantes es necesario y recomendable utilizar <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/\" title=\"Conexi\u00f3n a una base de SQL Server con SSIS\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10801,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[649],"tags":[],"class_list":{"0":"post-12021","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>Conexi\u00f3n a una base de SQL Server con SSIS - MS BI<\/title>\n<meta name=\"description\" content=\"Crear una nueva conexi\u00f3n a una base de datos de SQL Server con un paquete SSIS y el Administrador de Conexiones de Visual Studio.\" \/>\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\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conexi\u00f3n a una base de SQL Server con SSIS\" \/>\n<meta property=\"og:description\" content=\"Crear una nueva conexi\u00f3n a una base de datos de SQL Server con un paquete SSIS y el Administrador de Conexiones de Visual Studio.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriales de SQL y TI\" \/>\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=\"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=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Conexi\u00f3n a una base de SQL Server con SSIS\",\"datePublished\":\"2024-03-08T06:44:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/\"},\"wordCount\":620,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg\",\"articleSection\":[\"SSIS\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/\",\"url\":\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/\",\"name\":\"Conexi\u00f3n a una base de SQL Server con SSIS - MS BI\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-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\",\"description\":\"Crear una nueva conexi\u00f3n a una base de datos de SQL Server con un paquete SSIS y el Administrador de Conexiones de Visual Studio.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-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\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"es\",\"item\":\"https:\/\/expert-only.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Conexi\u00f3n a una base de SQL Server con SSIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/es\/#website\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"name\":\"Tutoriales de SQL y TI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/es\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/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\/es\/#\/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\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/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":"Conexi\u00f3n a una base de SQL Server con SSIS - MS BI","description":"Crear una nueva conexi\u00f3n a una base de datos de SQL Server con un paquete SSIS y el Administrador de Conexiones de Visual Studio.","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\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/","og_locale":"es_ES","og_type":"article","og_title":"Conexi\u00f3n a una base de SQL Server con SSIS","og_description":"Crear una nueva conexi\u00f3n a una base de datos de SQL Server con un paquete SSIS y el Administrador de Conexiones de Visual Studio.","og_url":"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/","og_site_name":"Tutoriales de SQL y TI","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-08T06:44:26+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":{"Escrito por":"Expert-Only","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Conexi\u00f3n a una base de SQL Server con SSIS","datePublished":"2024-03-08T06:44:26+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/"},"wordCount":620,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/one-hundred-64289A5CC0F_1920x1080.jpg","articleSection":["SSIS"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/","url":"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/","name":"Conexi\u00f3n a una base de SQL Server con SSIS - MS BI","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-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","description":"Crear una nueva conexi\u00f3n a una base de datos de SQL Server con un paquete SSIS y el Administrador de Conexiones de Visual Studio.","breadcrumb":{"@id":"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/ssis\/conexion-a-una-base-sql-server-con-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\/es\/ssis\/conexion-a-una-base-sql-server-con-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"es","item":"https:\/\/expert-only.com\/es\/"},{"@type":"ListItem","position":2,"name":"Conexi\u00f3n a una base de SQL Server con SSIS"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/es\/#website","url":"https:\/\/expert-only.com\/es\/","name":"Tutoriales de SQL y TI","description":"","publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/es\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/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\/es\/#\/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\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/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\/es\/wp-json\/wp\/v2\/posts\/12021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/comments?post=12021"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/12021\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media\/10801"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media?parent=12021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/categories?post=12021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/tags?post=12021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}