50 components to totally transform SQL Server Integration Services, filling in all the gaps for massively enhanced productivity, and enabling comprehensive xml, messaging and workflow scenarios.
BlueSSIS is a comprehensive library of extension components for SQL Server Integration Services that enables you to work more efficiently and intuitively, provides additional connectivity to a range of systems, and allows you to implement full messaging and workflow scenarios that would have previously required a tool like Microsoft BizTalk.
Microsoft SQL Server Integration Services, or SSIS as it is commonly known, has always been a great base platform, but it has also always been let down by a few rough edges. Additionally the inherrent power of the design surfaces has not been made available for message orchestration or workflow scenarios because of limitations in the standard component set. BlueSSIS changes all of this!
Our components can be broken down into the following categories :
Components that make it easier or less error-prone to perform common tasks, such as executing an upsert or merge statement, determining the differences between two databases or between two sessions of the same database, executing a simple expression, calling a stored procedure, merging outputs or sharing a single connection between OLEDB and ADO.Net components.
Components that send and receive messages, enabling the implementation of messaging scenarios by sending and receiving messages. A web service interface is provided enabling packages to process incoming request message, along with full bi-directional support for AS2, email, HTTP, MLLP, secure FTP and file system messaging. These messages can be in Xml, CSV, EDI, HL/7, delimited or positional text or binary formats.