{"id":3579,"date":"2023-04-12T15:39:33","date_gmt":"2023-04-12T15:39:33","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/"},"modified":"2026-01-15T18:13:28","modified_gmt":"2026-01-15T18:13:28","slug":"a-sql-server-integrated-services-ssis-exercise","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/","title":{"rendered":"How Do I Build and Run a Simple Data Integration Package Using SQL Server Integration Services (SSIS)?"},"content":{"rendered":"

SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You can use Integration Services to perform a variety of tasks such as maintaining data hubs that serve Planning Analytics or other enterprise applications.<\/p>\n

The following outlines the process of creating and deploying a working SSIS package that takes care of loading a staging table from a submitted CSV file as well as using data in an existing fact table to calculate a value and update a gross sales table.<\/p>\n

Prerequisites \u2013 getting set up<\/strong><\/p>\n

If you are lucky enough to have an environment preconfigured, wonderful! If not, you\u2019ll need to verify that you have working, and properly configured<\/em> versions of the tools needed. For this example, I am using Visual Studio 2017, MS SQL Server 2019, and SQL Server Management Studio (version 18.9.1). In addition to these tools, you will also need to make sure that the Integration Services (SSIS) feature is installed as well (SSIS is not installed by default so you may need to run the SQL Server installation again to add it).<\/p>\n

Creating a Project<\/strong><\/p>\n

Once you have your environment set, you need to create a \u201cspecial kind\u201d of visual studio project, that is, a \u201c Integration Services \u2013 Business Intelligence\u201d type project. To create a SSIS project, open Visual Studio and select Business Intelligence – Integration Services Project<\/em>.<\/p>\n

\"\"<\/p>\n

Next, name the project (I called mine Cycle Sales):<\/p>\n

\"\"<\/p>\n

The Connection Manager<\/strong><\/p>\n

Once Visual Studio has created a template project for you, the next step is to create a Microsoft SQL Server Integration Services package connection manager in the project. SQL Server Integration Services provides different types of connection managers that enable packages to connect to a variety of data sources and servers. For this project, we want to create a connection to a SQL Server. To do that, within the Visual Studio Solution Explorer, right click on Connection Managers<\/strong> and select New Connection Manager<\/strong>:<\/p>\n

\"\"<\/p>\n

On the Add SSIS Connection Manager<\/strong> dialog, you can select the type of connection you want to create. In this project I selected OLEDB and then followed the \u201cwizard\u201d to find and select the SQL Server instance that I want to target. Once you save the connection, you should see it in solution explorer:<\/p>\n

\"\"<\/p>\n

I am using the sample AdventureWorks2018 SQL Database and it is running in the SQL Server named SQLSERVER_2019 so I named my connection to reflect that.<\/p>\n

SSIS Toolbox<\/strong><\/p>\n

Now that we have a valid connection to use, we can proceed to create a flow. To do that, you\u2019ll need to have access to the SISS Toolbox. If you do not see it in Visual Studio, find the SISS Menu on the toolbar and click on SSIS Toolbox:<\/p>\n

\"\"<\/p>\n

In this project we are only going to use two tasks: The Bulk Insert Task<\/strong> which provides an efficient way to copy large amounts of data into a SQL Server table or view and the Execute SQL Task<\/strong> which runs SQL statements or stored procedures from a package.<\/p>\n

Importing Data to SQL Server<\/strong><\/p>\n

In this scenario, we have 2 CSV files. The first is a pricing file (cycle_prices.csv) and the other is a sales file (cycle_actual_volume.csv). In SQL Server, we have 3 target tables. They are Cycle_Price, Cycle_Sales and Cycle_Sales_Gross.<\/p>\n

The Cycle_Price table will hold the price for each product, the Cycle_Sales table will be loaded with sales volumes for each product (by month and year) and the Cycle_Sales_Gross table will ultimately hold the calculated gross sales for each product (again by month and year).<\/p>\n

I like to keep things \u201cclean\u201d and straight forward so I will create a separate SSIS task for each of the following:<\/p>\n

    \n
  1. Clear the Cycle_Price table<\/li>\n
  2. Bulk load the Cycle_Price table from the Cycle_Price.csv file<\/li>\n
  3. Clear the Cycle_Sales table<\/li>\n
  4. Bulk load the Cycle_Sales table from the Cycle_Sales.csv file<\/li>\n
  5. Clear the Cycle_Sales_Gross table<\/li>\n
  6. Bulk insert into the Cycle_Sales_Gross table<\/li>\n
  7. Update the Cycle_Sales_Gross table with calculated Gross Sales<\/li>\n<\/ol>\n

    Creating the Flow<\/strong><\/p>\n

    To create these tasks, you can select and then drag-and-drop the tasks from the SSIS Toolbox to the designer window, starting with a Execute SQL Task. Once in the designer window, you can right click it and select EDIT. In the Execute SQL Task Editor, <\/strong>you can fill in the General<\/strong> configuration properties.<\/p>\n

    \"\"<\/p>\n

    \u00a0<\/strong>\u00a0<\/strong>Name<\/strong> – provide a descriptive Name<\/p>\n

    ResultSet<\/strong> – should be set to None<\/p>\n

    ConnectionType<\/strong> – should be OLE DB<\/p>\n

    Connection<\/strong> \u2013 select the connection we set up earlier.<\/p>\n

    SQLSourceType<\/strong> \u2013 Direct Input<\/p>\n

    SQLStatement<\/strong> \u2013 you can use the Build Query feature, but since the example is really simple, you can just type in:<\/p>\n

     <\/p>\n

    DELETE FROM Cycle_Price<\/p>\n

    Click OK<\/strong>.<\/p>\n

    Next, we can add a Bulk Insert Task<\/strong> in the same manner. Edit it, and change configurations under 3 areas, General, Connection and Options. Under General<\/strong>, just provide a descriptive name:<\/p>\n

    \"\"<\/p>\n

    under Connection<\/strong>, we need to again select same connection as we did for the Execute SQL Task and also provide the target table name (Cycle_Price) and finally the source price file (cycle_pricess.csv):<\/p>\n

    \"\"<\/p>\n

    Lastly, under Options, we need to tell SSIS that the data begins in the second row\/record I the file:<\/p>\n

    \"\"<\/p>\n

    After the above steps have been completed, in the designer window, we can use the mouse to connect the tasks with the green flow arrow to indicate the sequence in which the SSIS package should execute our tasks (first clear the price table then load the latest product prices into the table):<\/p>\n

    \"\"<\/p>\n

    Since we now understand how \u201cclear and load\u201d tasks work, we can just repeat the above steps to clear the cycle_sales and cycle_sales_gross tables and then (bulk) load the cycle_sales table from the Cycle_Sales.csv file and then add those tasks to our flow:<\/p>\n

    \"\"<\/p>\n

    The last 2 steps will populate the cycle_sales_gross table and then calculate the Gross_Sales value. Both of these tasks will be accomplished using Execute SQL Tasks. To populate the cycle_gross_sales table, add an Execute SQL Task and again edit the General configuration properties as follows:<\/p>\n

    \"\"<\/p>\n

    Name<\/strong> – a descriptive Name<\/p>\n

    ResultSet<\/strong> – None<\/p>\n

    ConnectionType<\/strong> – OLE DB<\/p>\n

    Connection<\/strong> \u2013 select the connection we set up earlier.<\/p>\n

    SQLSourceType<\/strong> \u2013 Direct Input<\/p>\n

    SQLStatement<\/strong> \u2013 you can use the Build Query feature, but again since the example is really simple, you can just type the SQL statement. We are going to use the Cycle_Sales to populate the Cycle_Sales_Gross table so our SQL would look like this:<\/p>\n

    \"\"<\/p>\n

    The complete project now looks like this:<\/p>\n

    \"\"<\/p>\n

    Make sure you save the project. You can test it within in Visual Studio by clicking Start<\/strong>. Visual Studio will alert you of any errors in the package. In addition, you can always use Management Studio to query the tables and verify the results.<\/p>\n

    Time to Build it<\/strong><\/p>\n

    Once you are satisfied that they project successfully meets your requirements, you need to create a file that can be deployed and run in SQL Server. To do that, you click on Build<\/strong> then Build Cycle Sales<\/strong>:<\/p>\n

    \"\"<\/p>\n

    This will perform a sort of compilation of the project and create an Integration Services Project Deployment File: Cycle Sales.isapc which can then be deployed and executed in SQL Server. Once the file is created you can use Management Studio to log into the database and perform the following steps:<\/p>\n

    1. Locate the Integration Services Catalogs<\/strong><\/p>\n

    2. Under the Integration Services Catalogs node, locate the folder \u201cDeployed Projects<\/strong>\u201d and expand it (if it doesn\u2019t exist, you can create one).<\/p>\n

    3. Right click on the folder \u201cProjects<\/strong>\u201d<\/p>\n

    \"\"<\/p>\n

    4. Select Deploy Project\u2026<\/strong><\/p>\n

    5. Follow the instructions on the Integration Services Deployment Wizard<\/strong><\/p>\n

    \"\"<\/p>\n

    Select the project deployment file option and then browse to the .isapc file we just created.<\/p>\n

    \"\"<\/p>\n

    Select the SSIS in SQL Server option.<\/p>\n

    \"\"<\/p>\n

    Select the target server name and location (path) where the package will reside and run from.<\/p>\n

    \"\"<\/p>\n

    The wizard will validate the package and once successfully validated, you can then click Deploy. Our package is now deployed and ready to run:<\/p>\n

    \"\"<\/p>\n

    To execute the package, expand Cycle Sales and right click on Package.dtsx and select Execute\u2026<\/strong><\/p>\n

    \"\"<\/p>\n

    On the Execute Package dialog, click on OK.<\/p>\n

    \"\"<\/p>\n

    The following popup should appear:<\/p>\n

    \"\"<\/p>\n

    Click Yes. The package will run, and the following Execution Information will be displayed:<\/p>\n

    \"\"<\/p>\n

    We now have created our very own working SSIS package!<\/p>\n","protected":false},"excerpt":{"rendered":"

    SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You can use Integration Services to perform a variety of tasks such as maintaining data hubs that serve Planning Analytics or other enterprise applications. The following outlines the process of creating and deploying a working SSIS package that takes…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[27],"tags":[65,32],"class_list":["post-3579","post","type-post","status-publish","format-standard","hentry","category-quebit-value","tag-featured","tag-sql"],"acf":[],"yoast_head":"\nHow Do I Build and Run a Simple Data Integration Package Using SQL Server Integration Services (SSIS)? - QueBIT<\/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:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Build and Run a Simple Data Integration Package Using SQL Server Integration Services (SSIS)? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You can use Integration Services to perform a variety of tasks such as maintaining data hubs that serve Planning Analytics or other enterprise applications. The following outlines the process of creating and deploying a working SSIS package that takes…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-12T15:39:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-15T18:13:28+00:00\" \/>\n<meta name=\"author\" content=\"agoddard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"agoddard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/\"},\"author\":{\"name\":\"agoddard\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"headline\":\"How Do I Build and Run a Simple Data Integration Package Using SQL Server Integration Services (SSIS)?\",\"datePublished\":\"2023-04-12T15:39:33+00:00\",\"dateModified\":\"2026-01-15T18:13:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/\"},\"wordCount\":1415,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/SI1-min.jpg\",\"keywords\":[\"Featured\",\"SQL\"],\"articleSection\":[\"QueBIT Value\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/\",\"name\":\"How Do I Build and Run a Simple Data Integration Package Using SQL Server Integration Services (SSIS)? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/SI1-min.jpg\",\"datePublished\":\"2023-04-12T15:39:33+00:00\",\"dateModified\":\"2026-01-15T18:13:28+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/SI1-min.jpg\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2021\\\/09\\\/SI1-min.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/a-sql-server-integrated-services-ssis-exercise\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Build and Run a Simple Data Integration Package Using SQL Server Integration Services (SSIS)?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/e52d72da0fd2f5f70d189343fe4f5084\",\"name\":\"agoddard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g\",\"caption\":\"agoddard\"},\"sameAs\":[\"https:\\\/\\\/quebit.com\\\/askquebit\"],\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/agoddard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Build and Run a Simple Data Integration Package Using SQL Server Integration Services (SSIS)? - QueBIT","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:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Build and Run a Simple Data Integration Package Using SQL Server Integration Services (SSIS)? - QueBIT","og_description":"SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You can use Integration Services to perform a variety of tasks such as maintaining data hubs that serve Planning Analytics or other enterprise applications. The following outlines the process of creating and deploying a working SSIS package that takes…","og_url":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/","og_site_name":"QueBIT","article_published_time":"2023-04-12T15:39:33+00:00","article_modified_time":"2026-01-15T18:13:28+00:00","author":"agoddard","twitter_card":"summary_large_image","twitter_misc":{"Written by":"agoddard","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/"},"author":{"name":"agoddard","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"headline":"How Do I Build and Run a Simple Data Integration Package Using SQL Server Integration Services (SSIS)?","datePublished":"2023-04-12T15:39:33+00:00","dateModified":"2026-01-15T18:13:28+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/"},"wordCount":1415,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/09\/SI1-min.jpg","keywords":["Featured","SQL"],"articleSection":["QueBIT Value"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/","url":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/","name":"How Do I Build and Run a Simple Data Integration Package Using SQL Server Integration Services (SSIS)? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/09\/SI1-min.jpg","datePublished":"2023-04-12T15:39:33+00:00","dateModified":"2026-01-15T18:13:28+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/09\/SI1-min.jpg","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2021\/09\/SI1-min.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/a-sql-server-integrated-services-ssis-exercise\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Build and Run a Simple Data Integration Package Using SQL Server Integration Services (SSIS)?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/e52d72da0fd2f5f70d189343fe4f5084","name":"agoddard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d817b364cff1d66116debde8d1c85e5e76eeece9c5ae731b19276a6040231455?s=96&d=mm&r=g","caption":"agoddard"},"sameAs":["https:\/\/quebit.com\/askquebit"],"url":"https:\/\/quebit.com\/askquebit\/author\/agoddard\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3579","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=3579"}],"version-history":[{"count":2,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3579\/revisions"}],"predecessor-version":[{"id":4914,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/3579\/revisions\/4914"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=3579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=3579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=3579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}