Microsoft SQL Server Integration Services

Microsoft SQL Server Integration Services (SSIS) provides us with a standard suite of intuitive tools for building solutions to extract, transform and load (ETL) data from many disparate sources.

We here at Leale Solutions have extensive experience with Microsoft SQL Server Integration Services (SSIS). We have used Microsoft SQL Server Integration Services (SSIS) for can data cleansing, data warehousing, data workflows, data process management.

We use Microsoft SQL Server Integration Services (SSIS) to provide a framework for smart ETL

by leveraging the power of SSIS variables, expressions, and decision-making capabilities with precedence constraints and evaluation. As long experienced professionals of the SQL Server platform and features, we were early adopters of the SSIS predecessor Data Transformation Services (DTS). DTS was a tool that had limitations. SSIS is a mature ETL tool that separated control and data flow tasks for ease of use and granular control of task steps. We are experienced with SSIS over a wide range of features and functions which include:

  • For (and for each) loops including shredding (ADO and ADO.Net) record sets.
  • SSAS cube processing.
  • Event handlers for error handling, changed workflows, calling child packages.
  • Notifications.
  • Derived columns.
  • Conversions.
  • Multicast operations.
  • FTP, native to SSIS.
  • SSH, SFTP and FTPS operations utilizing 3rd party tools such as CozyRoc.
  • 3rd party drivers for DB2 and Informix.
  • Connections to most major and minor common data sources including SQL 7.0 and above, Raw text files, Ragged text files, Pipe delimited files, Excel 97and above, Access 97and above, Oracle version 8i and above, DB2, Informix, Sybase, XML.
  • Web Services integration.
  • File System integration.
  • Email messaging.

We employ best practices at all times. We use SSIS package templates to ensure error handling, notifications and other standards are followed every time.

We are experienced in creating and maintaining robust data structures wall while updating these from various sources such as XML, Web Services, flat files, and relational data sources. Integration Services offers a rich set of built-in tasks and transformations; tools for constructing packages; and the service for running and managing packages.

microsoft sql server integration services

Final Thought

Using Microsoft SQL Server Microsoft SQL Server Integration Services (SSIS) we here at Leale Solutions can build smart ETL processes that are robust to fit your specialized needs. We institute best practices for ETL and leverage the Microsoft SQL Server Microsoft SQL Server Integration Services (SSIS) platform to ensure required items such as error handling, alerting and notifications are in place from the start. Contact us to discuss your next successful Microsoft SQL Server Microsoft SQL Server Integration Services (SSIS) success.