This project is read-only.

BlueHub Tasks and Components

BlueSSIS is a company that develops custom Tasks and Components for SSIS.

Company Website: www.bluessis.com

Control Flow Tasks

  • AS2 Receive - Allows SQL Server Integration Services packages to receive AS2 messages over the Internet.
  • AS2 Send - Allows SQL Server Integration Services packages to send AS2 messages over the Internet.
  • Certificate - The Certificate Component allows data to be validated or signed / encrypted based on X509 certificate security.
  • Convert - The Convert Component allows you to convert a message between EDI, Xml, HL/7, delimited, positional and binary formats.
  • Email - The Email Component allows you to receive and process POP3 emails.
  • File - The File Component allows you to locate, read and write files much more flexibly than under vanilla SQL Server Integration Services.
  • FTP - The FTP Component allows you to enumerate, read or write files via FTP, FTPS or SFTP. In addition to supporting secure FTP this component is much more flexible than the standard SSIS one.
  • HL7 Ack - The HL7 ACK Component will automatically generate an acknowledgement message for an incoming HL7 v2.x message.
  • HTTP - The HTTP Component allows you to send and receive messages via HTTP or HTTPS.
  • Log Variables - The Log Variables Component allows you to dump the current state of the package variables to the Windows event log.
  • MLLP Receive - The MLLP Receive Component allows you to receive MLLP messages via TCP. MLLP is typically used for HL/7 messages.
  • MLLP Respond - The MLLP Respond Component allows you to send a response for an incoming MLLP message.
  • MLLP Send - The MLLP Send Component allows you to send an MLLP message.
  • OLEDB Bridge - The OLEDB Bridge Component allows you to use a common connection for components requiring both OLEDB and ADO.Net connections.
  • Simple Transaction Begin - The Simple Transaction Begin allows you to manage database transactions across individual connections without the use of DTC.
  • Simple Transaction Commit - The Simple Transaction Commit allows you to manage database transactions across individual connections without the use of DTC.
  • Simple Transaction Rollback - The Simple Transaction Rollback allows you to manage database transactions across individual connections without the use of DTC.
  • Sleep - The Sleep Component provides a simple way of sleeping for a given nyumber of milliseconds, for example in a polling scenario.
  • SQL Component - The SQL Component provides a strongly types intuitive and graphical way of inserting, updating, deleting, upserting or merging data, executing a stored procedure, or executing tokenised SQL.
  • Web Service Call - The Web Service Call Component allows you to easily consume web services.
  • Web Service Receive - The Web Service Receive Component allows you to wait for and pick up incoming data from a web service.
  • Web Service Respond - The Web Service Respond Component allows you to return a response for a web service call.
  • XML Transform - The Xml Transform Component allows you to map from one Xml format to another via a sophisticated and flexible graphical mapping tool, and also enables you to convert between Xml and EDI, Xml, HL/7, delimited, positional or binary formats.

Foreach Loop Enumerators

  • File - File enumerator.
  • FTP File - FTP File enumerator.
  • AS2 Message - AS2 Message enumerator.
  • Email Message - Email Message enumerator.
  • MLLP Message - MLLP Message enumerator.
  • Web Service Message - Web Service Message enumerator.
  • Infinite Loop - Infinte loop enumerator.
  • Loop Once - Loop once enumerator.
  • SQL - SQL enumerator.

Data Flow Components

Sources

  • Microsoft CRM Source - The Microsoft CRM Source allows you to read data from Microsoft CRM versions 3.0 and beyond.
  • Microsoft Sharepoint Source - Allows you to read list data from Microsoft SharePoint 2007 and beyond.
  • SQL - The SQL Component provides a strongly types intuitive and graphical way of inserting, updating, deleting, upserting or merging data, executing a stored procedure, or executing tokenised SQL.
  • XML Source - The Xml Source Component allows you to expand Xml data into column data, where the originating Xml data comes from a data-flow column or a variable. This component also enables you to convert to Xml from EDI, Xml, HL/7, delimited, positional or binary formats.

Transforms

  • Advanced Map - The Advanced Map Component allows you to define sophisticated data transformations graphically.
  • Basic Map - The Basic Map Component allows you to define simple and flexible value mappings.
  • Change Filter - The Change Filter Component efficiently compares the entire state of a data-flow with the state at the time it was last row, breaking down all changes into inserted, updated or deleted rows that can then be routed differently. This component can also be used to compare two separate databases.
  • Commit Change Filter - The Commit Change Filter Component commits the current state of the data-flow as the reference source.
  • Cross Join - The Cross Join Component allows you to merge, correlate and manipulate data from multiple sources.
  • Expression - The Expression Component avoids the requirement to have to write opaque VSTA code to execute even the simplest bit of logic, enabling simple expressions relating to tasks such as incrementing a variable or formatting a date to be written easily. Expressions can reference variables, columns and .Net Framework code, and the result can be stored in a column or variable.
  • If/Then/Else - The If/Then/Else provides a straightforward and intuitive way of implementing simple conditional logic.
  • If/Then/Multicast - The If/Then/Multicast provides a straightforward and intuitive way of implementing simple conditional logic.
  • Lookup - The Lookup Component allows lookup logic to be graphically defined. The existing SQL Server Integration Services component for this role is not actually bad, but there is a problem with caching dynamic data and it is effectively useless for looking up a value from a table or view thaty may actually be changed by your package. For example a typical use of a lookup component is to see if some peripheral data exists and create it if not.
  • Microsoft CRM Lookup - The Microsoft CRM Lookup allows you to look up data from Microsoft CRM versions 3.0 and beyond.
  • Organize Columns - The Organize Columns Component allows you to delete, rename, re-order and filter columns within a data-flow.
  • SQL - The SQL Component provides a strongly types intuitive and graphical way of inserting, updating, deleting, upserting or merging data, executing a stored procedure, or executing tokenised SQL.
  • Unicode Conversion - The Unicode Conversion Component provides a strightforward way of mapping all string fields in a data-flow to unicode or ansi format.
  • Union All - The Union All Component merges data-flow outputs together, but in a dynamic way - that is the output fields are always updated automatically based on the inputs.
  • Web Service Call - The Web Service Call Component allows you to easily consume web services.
  • Zip - The ZIP Component allows data to be compressed or decompressed.

Destinations

  • Microsoft CRM Destination - The Microsoft CRM Destination allows you to write data to Microsoft CRM versions 3.0 and beyond.
  • Microsoft CRM Update - The Microsoft CRM Destination allows you to update data in Microsoft CRM versions 3.0 and beyond.
  • Microsoft Sharepoint Update - Allows you to update list data in Microsoft SharePoint 2007 and beyond.
  • Oracle Bulk Loader - The Oracle Bulk Loader Component allows you to bulk insert data into Oracle more efficiently than using the standard ADO.Net or OLEDB provider.
  • SQL - The SQL Component provides a strongly types intuitive and graphical way of inserting, updating, deleting, upserting or merging data, executing a stored procedure, or executing tokenised SQL.
  • XML Destination - The Xml Destination Component allows you to create Xml data from column data, and then write this Xml data to a data-flow column or a variable. This component also then enables you to convert the Xml to EDI, Xml, HL/7, delimited, positional or binary formats.

Reviews: None

Last edited Jan 19, 2011 at 11:44 PM by toddmcdermid, version 4

Comments

No comments yet.