XML has become the defacto standard for information exchange across the web. The Task Factory SSIS XML Destination, one of the many components found in Pragmatic Works’ Task Factory suite, makes it incredibly easy to create XML files from your SQL Server Integration Services packages. In this video, you will see just how simple it is to generate easy to read XML files.
Inserting and updating records is, without a doubt, the most common operation performed in any SQL Server Integration Services package. What a headache though, having to determine if the record exists, whether to insert it, stage it, etc.
All that goes away with the Task Factory SSIS Upsert Destination component, part of the Task Factory suite from Pragmatic Works. With one simple control you can handle both inserts and updates with ease. This video shows you how incredibly easy it is.
The Case Transform, an SSIS component in the Task Factory suite from Pragmatic Works, allows you to easy correct the capitalization mistakes found in many source systems. This video demonstrates how easy it is to use the Task Factory Case Transform SSIS component.
One of the most common tasks for SSIS developers is to replace characters or words in a column with a new set of characters, or a new word. Sure, you can use a derived column transform, then fiddle around with substrings, but geez what a pain that is. Fortunately Task Factory, a suite of SSIS components from Pragmatic Works, has a great tool to make this quick and easy: The Replace Unwanted Characters transformation. This video demonstrates how easy it is to use.
Disclaimer, In case it’s not obvious I do work for Pragmatic Works.
My last video on the Task Factory Compression Task was well received, so I thought I’d build on it with a video on the File Properties Task. It’s a cool little tool that will grab any of the various attributes associated with a file. If you want to see more about Task Factory, you can head on over to my employers website, Pragmatic Works.com
In previous posts I’ve been working through some of the Task Factory components. As many of you know I went to work for Pragmatic Works earlier this year. Since then I’ve been learning all our tools, and since there’s no better way to learn than by teaching am creating blog posts about these tools.
Today I thought I’d look at the TF Compression Task. They say a picture is worth a thousand words, not sure what that converts to in term of video but I feel it must be a lot. So without further delay, here is my video showing how to use the TF Compression Task. You can also find it directly on You Tube at http://bit.ly/tfcompression
I wanted to let everyone know some exciting news. Starting March 21st I’ll be going to work at Pragmatic Works! Pragmatic Works has a great variety of tools for SQL Server Business Intelligence, training videos, books, as well as a thriving consulting division.
While I’ll miss my friends over at Comframe I’m very excited to be joining one of the premier BI consulting firms in the US. This promises opportunities for even more speaking engagements, as well as multiple outlets for content creation.
Here’s to a Pragmatic future!