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
511 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,870 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, 2020 by MD
• 95,360 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 in Others by narikkadan
• 11,280 points
94 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 in Others by Kichu
• 19,040 points
95 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 in Others by nisha
• 2,180 points
35 views
0 votes
1 answer

Creating custom property for .net assembly

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

answered Nov 13, 2018 in Others by DataKing99
• 8,240 points
195 views
+2 votes
2 answers
+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
914 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,870 points
288 views
0 votes
0 answers

programming logic! :O

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

Jun 11 in C# by jyoti
• 1,240 points
9 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,870 points
118 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,870 points
1,046 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP