123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Technology,-Gadget-and-Science >> View Article

Sql Server Integration Services: Another Perspective

Profile Picture
By Author: Team USATInc
Total Articles: 49
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

According to Microsoft (see reference 1 below), the maker of the SQL Server Integration Services (SSIS) “SSIS is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.” SSIS is an integral part of Business Intelligence, which software is available from multiple sources, including Microsoft.

SSIS is essentially a solution for automating a Structured Query Language (SQL) Server. Packages are built of tasks that can move data from place to place and alter it enroute. Visual designers, hosted within Business Intelligence Development Studio (BIDS), a software suite, help build these packages as well application programming interfaces (API) for programming SSIS objects from other applications.

SSIS lends itself to customization. Microsoft has made the job easier by creating a simple wizard that takes care of common ETL tasks, namely, importing data to or exporting it from an SQL database. Data can be easily shuffled between SQL Server databases, Flat files, MS Access databases, MS Excel worksheets and other Object ...
... Linking and Embedding- Database (OLE DB) providers. A number of shortcuts are also provided by the wizard.

Wizard apart, SSIS is a truly powerful tool, particularly when BIDS is used to build an SSIS package, i.e., a collection of SSIS objects like connections to data sources; data flows to ETL ports, sources and destinations; transformations of data and the links between them; control flows, i.e., tasks that can be organized in sequences or in loops and event handlers, workflows that are called in response to events raised by a package or a task, etc. SSIS uses connection managers to integrate different data sources into packages which are then moved from place to place. Some examples of connection managers are:

a) Excel Connection Manager - Connecting to an Excel worksheet.
b) File Connection Manager- Connecting to a file or folder.
c) File Transfer Protocol (FTP) Connection Manager- Connecting to an FTP data source.

The SSIS is given orders using the Control Flow tab. Data is then picked up from the source, dragged and dropped at the destination and a connection established between them.

Examples of tasks are maintenance plans, server integrity checks, inter-SQL data transfer, etc. The Data Flow tab is used to describe details of any Data Flow tasks added to the Control Flow, a method of inserting data into the system. Moreover, it is possible to alter and manipulate data in various ways, using transformations. SSIS packages also support all events, while saving and running the system.

References:

1.http://msdn.microsoft.com/en-us/library/ms141263.aspx

Total Views: 290Word Count: 420See All articles From Author

Add Comment

Technology, Gadget and Science Articles

1. [enterprise Performance Management] Epm Software Benefits For Businesses
Author: BiCXO

2. Progressive Web Apps: The Future Of Mobile Development Innovation
Author: Digiprima Technologies

3. Challenges And Solutions In Migrating From Firebird To Postgresql – Ask On Data
Author: Vhelical

4. Why Hybrid Mobile App Development Is The Smart Choice For Businesses
Author: Egrove System

5. Maximize Your Space With Custom Led Video Walls For Your Office
Author: Maximize Your Space with Custom LED Video Walls

6. Why Compliance Pharmaceutical Industry Matters: A Complete Guide
Author: Jesvira

7. 10 Advantages Of Full Stack Java Development Careers In India
Author: Rohan Rajput

8. Goquo: Revolutionizing Airline Retailing With Advanced Technology Solutions
Author: Moondeep

9. Quick Commerce Data Scraping 2025 For Competitive Intelligence
Author: Devil Brown

10. Isaca Introduces Certified Cybersecurity Operations Analyst (ccoa) Credential
Author: Madhulina

11. How A Minimalist Ui Design Can Transform Your Shopify Store’s Conversions
Author: Miten

12. Why Malgo Is The Top Choice For Metaverse Development? : A Comprehensive Guide
Author: andrewkamal

13. Boosting Decision-making With Open Source Bi
Author: Vhelical

14. Isaca Awards Celebrate Impactful Contributions Of Tech Professionals
Author: Madhulina

15. Why Rfid Tags Are The Future Of Airport Baggage Handling
Author: Sankalp Singh

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: