Wires Microsoft's Balanced Data Distributor (BDD) custom component into a dataflow so a single OLE DB source feeds two parallel OLE DB destinations writing to the same table, splitting rows round-robin via two BDD output paths in an ExclusionGroup.
Wires the 'Error' outputs of a DataConversion and an OleDbDestination into a single UnionAll, drops unused columns from one of the inputs via 'IsUsed="false"', and writes the merged failed rows to a flat file destination.
Wires two parallel dataflows through the third-party COZYROC Flow Synchronization custom component (referenced via 'CustomComponent') so both dataflows advance in lock-step at the same throughput, sharing a named semaphore and a MaxDelta buffer threshold.
Uses two instances of the third-party COZYROC Lookup Plus component (referenced via 'CustomComponent') to enrich rows in a dataflow: the first looks up a JobTitle from a hard-coded reference query, the second looks up a NationalIDNumber from a query stored in a package variable, then routes the result to a Konesans Trash Destination.
In this webinar we will go through the pattern required to migrate workloads to Azure. This session will be a live BimlScript demonstration with hardly...
Terminates a dataflow path with the Konesans Trash Destination (declared via 'CustomComponent'), letting you exercise an SSIS dataflow during development without actually writing the data anywhere.
Describes an end-to-end process for setting up Oracle XE and accessing data from SSIS using the Attunity Oracle Connection with Biml.
Adds the third-party COZYROC Zip task to a package via 'CustomTask', configuring it to compress a single source file connection to a destination .zip file connection using a Zip-format ObjectData payload.