<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Category: Products

19 Results

Send Emails in SSIS Using Task Factory's Advanced Email and SMS Task

Posted Mar 16, 2016 by Ken Wood

The Advanced Email and SMS Task from Task Factory is more than just a tool used to send Emails and SMS Text Messages with SSIS. As the name suggests, it’s “Advanced”; of course we can do more with the Advanced Email and SMS Task

Using Task Factory’s REST API Source to Connect to Zendesk

Posted Mar 08, 2016 by Manuel Quintana

Greetings everyone! Today we are going to create an SSIS package using the REST API Source component from Task Factory. Specifically, we are going to use this source component to connect to Zendesk’s API service. When using the REST API Source to connect to any service you must be knowledgeable on how that particular API and what are valid API endpoints.

Incrementally Loading Data from Salesforce

Posted Mar 02, 2016 by Brian Knight

As a business owner and someone who is responsible for sales, reporting in SalesForce.com is challenging to say the least. The reporting is tightly restricted to a few objects and the interface can't create the beautiful reports that those in the data industry are used to seeing. Most importantly, I can't merge the data with my existing data sources like data from accounting, HR or our other internal systems. This is why most people pull data from SalesForce.com into a central reporting database to do more advanced reporting. This blog shows you my method for pulling data into a single repository for further reporting.

Using the Task Factory REST Source with GoToWebinar

Posted Feb 25, 2016 by Shawn Harrison

Today, I'm going to show you an easy way to use REST API calls to bring data into SSIS. Task Factory has a new REST Source that enables users to retrieve data from websites using the REST API. It's a rather powerful source component that can be used in a number of ways. I want to focus on general usage and how to split values into separate columns when retrieving data in JSON format.

Performing Joins Within the Salesforce Source from Task Factory

Posted Feb 16, 2016 by Ken Wood

The question has been posed many times, “Is it possible to perform joins with Task Factory’s SalesForce Source component?” The answer is a resounding “YES!” Not only is it possible, but it’s actually very simple.

Types of Testing in the Data-Centric World

Posted May 19, 2015 by Robert Cain

Testing has long been accepted in the software development world as the key to quality. Testing ensures code behaves as designed, delivers the expected results even after subsequent changes to the original code base occur and that code changes from one developer do not adversely affect the existing code base. Done correctly, it also verifies that the code handles an appropriate range of input data and manages exceptions and invalid data correctly.

Object Variable: How to Make Your Packages Dynamic in SSIS

Posted Feb 23, 2015 by Manuel Quintana

Greetings everyone, and thank you for taking the time to look at this blog. This is my first post and I hope I’m able to answer some of your questions about building packages in SSIS. In this post I will be showing you how to use the object variable to make packages dynamic while using Task Factory, a SSIS product by Pragmatic Works.

Download Emails & Email Attachments in SSIS

Posted Feb 03, 2015 by Mitchell Pearson

Ever need to download emails and attachments using SSIS? If so you have come to right the place. Task Factory, a suite of custom SSIS components by Pragmatic Works has a component called the Email Source. This feature allows you to pull content directly from an email into a data flow.The component supports both POP3 and IMAP and is really easy to set up, so let’s get started!

Introducing BI xPress Server

Posted Jan 26, 2015 by Liz Hamilton

We are exicted to announce the launch of BI xPress Server! BI xPress Server joins the DOC xPress Server in our Workbench Server line of products. Our line of server products gives your business and technical users access to your company's data, without requiring them to have a desktop installation. 

Blog Comments

Need help with this topic? Ask the author below.


Subscribe to Blog Updates