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 in Others by vnk
• 370 points
46 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 13 by Gitika
• 49,580 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. I suggest you go through the link once.

https://www.guru99.com/ssis-tutorial.html

answered Oct 14 by MD
• 79,190 points

Related Questions In Others

0 votes
1 answer

Creating custom property for .net assembly

While your compiler does not really support ...READ MORE

answered Nov 12, 2018 in Others by DataKing99
• 8,210 points
78 views
+2 votes
2 answers
0 votes
1 answer

Get files in my own file format for its own dynamic icon

Regarding MAC support, "The Mac and Windows ...READ MORE

answered Jan 8, 2019 in Others by DataKing99
• 8,210 points
295 views
0 votes
1 answer

Where is the documentation to refer for coinbase api integration of Etherium coin currency in php?

Hey there! Please refer to the following ...READ MORE

answered Jan 25, 2019 in Others by Omkar
• 69,030 points
124 views
0 votes
0 answers

Wafcoin: Legalization is the cornerstone for long-term development

Wafcoin token trading platform has always insisted ...READ MORE

Jan 29, 2019 in Others by anonymous
67 views
0 votes
2 answers

Datasets for data science projects

Google has launched a separate search engine ...READ MORE

answered Feb 11, 2019 in Others by Faizal
1,054 views
+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,280 points
434 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 in Ask us Anything! by Gitika
• 49,580 points
100 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 in Others by Gitika
• 49,580 points
323 views
0 votes
1 answer