Prepare Document for SSIS

0 votes
Prepare Document for SSIS(ETL).  i need all details ( Overview) for the SSIS tool. we need at least 10 to 15 lines.

below are the details for which are under below categories for SSIS and SSRS

1) Business Overview  2) Functional Details 3) Technical Details 4) Code Walkthrough 5) Process/Procedure

ex:

Categories                               Subject

Business Overview                 Application Overview

----
Oct 13, 2020 in Others by vnk
• 390 points
1,678 views

2 answers to this question.

0 votes

Hi, @Vnk,

Server 2005 Integration Services (SSIS) introduces a rich toolset that supports the development, deployment, and administration of the extract, transform load (ETL) solutions. The Integration Services tools for developing and configuring packages, the tools that are available in Business intelligence Development studio.

1) In Business Intelligence Developments Studio, you develop your business solutions in the context of a solution and a project. A solution is a container that manages multiple projects as one unit. Typically, the projects in a solution are related, and together they support a business solution. A solution can include different types of projects such as Integration Services Analysis Services, or Reporting service projects.

I am listing two videos for you might help you to learn and get more insight on how SSIS and SSRS works:

https://www.youtube.com/watch?v=0ikNnenDyNw

https://www.youtube.com/watch?v=hsf9tpxe_LI

Moving On

2) Functional Details

SQL Server Integration Service (SSIS) is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. SSIS is a fast & flexible data warehousing tool used for data extraction, loading and transformation like cleaning, aggregating, merging data, etc.

It makes it easy to move data from one database to another database. SSIS can extract data from a wide variety of sources like SQL Server databases, Excel files, Oracle and DB2 databases, etc.

I would even suggest you to go through the blog here https://www.edureka.co/blog/ssis-tutorial/

3) Technical Details

In SSIS tool, you can add a task to control flow. There are different types of tasks which perform various kinds of works.

Some important SSIS tasks are mentioned below:

  • Execute SQL Task:- As its name suggests, it will execute a SQL statement against a relational database.
  • Execute Package Task:- Use can use this SSIS task to execute other packages from within the same project.
  • FTP Tasks:- It allows you to perform basic FTP functionalities.

4) Code walkthrough

I guess for a good hands-on you must visit here: https://www.youtube.com/watch?v=0ikNnenDyNw&t=26s and https://www.edureka.co/blog/sql-server-management-studio/

5) Process

The Execute Process task can be used to run an application or a batch file as one of the steps in an SSIS package. The input, output and arguments of the application can be set in the editor of the task and be used at run-time.

I hope the information will be helpful for you!!!


 

answered Oct 14, 2020 by Gitika
• 65,770 points
0 votes

Hi@vnk,

SQL Server Integration Service (SSIS) is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. SSIS is a fast & flexible data warehousing tool used for data extraction, loading, and transformation like cleaning, aggregating, merging data, etc. You can get the complete information from the below-given link.

answered Oct 14, 2020 by MD
• 95,460 points

Related Questions In Others

0 votes
1 answer

AngularJS SEO for 404 Status for Document Similar to This Website

angular.module('app', ['ui.router']) ...READ MORE

answered Feb 28, 2022 in Others by narikkadan
• 63,600 points
1,066 views
0 votes
0 answers

How is it possible for DynamoDB to support both Key-Value and Document database properties at the same time

As per DynamoDB's documentation, it supports both ...READ MORE

Apr 5, 2022 in Others by Kichu
• 19,040 points
757 views
0 votes
1 answer

How to prepare an APK for the Amazon Android App Store

you should use zipalign during every build, ...READ MORE

answered Jun 1, 2022 in Others by nisha
• 2,210 points
647 views
0 votes
1 answer
+6 votes
5 answers

can't remove SSIS variables using remove method on PowerShell

you're missing the additional $environment.Alter() after your ...READ MORE

answered Mar 27, 2018 in DevOps & Agile by ajs3033
• 7,300 points
2,675 views
0 votes
1 answer

I have 2.7 years of work experience.

Hi, @Saleemhopes, If u have 2.7 years of work ...READ MORE

answered Jun 4, 2020 in Ask us Anything! by Gitika
• 65,770 points
936 views
0 votes
0 answers

programming logic! :O

I am inside script task of SSIS. ...READ MORE

Jun 11, 2022 in C# by jyoti
• 1,240 points
307 views
0 votes
0 answers

What is the advantage of using "Set NOCOUNT ON" in stored procedure's which are used in ssis packages?

While studying SQL Server's performance tuning concepts, ...READ MORE

Aug 28, 2022 in Database by Kithuzzz
• 38,000 points
562 views
0 votes
1 answer

What are the different requirements for legal document translation services

Hi, @Henrycragi Thanks for the information. READ MORE

answered Nov 30, 2020 in Others by Gitika
• 65,770 points
556 views
0 votes
2 answers

Is Peterson’s Algorithm a good solution for Critical Section problem? If yes, then why? If no, then why?

Peterson’s solution provides a good algorithmic description ...READ MORE

answered Jul 6, 2020 in Others by Gitika
• 65,770 points
2,305 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP