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

Category: Task Factory

34 Results

Faster and Cleaner SSIS Loads with Task Factory

Posted Nov 15, 2017 by Pragmatic Works


Let’s face it, many of us have performance issues with SSIS. Would you like to learn how to load your data up to 3000% faster? Who wouldn’t, right? Now imagine this with the benefit of creating cleaner data. Sound too good to be true?

What's Going On in November?

Posted Nov 01, 2017 by Pragmatic Works

We're kicking off the month exhibiting at PASS Summit 2017 in Seattle, WA and hosting our 6th annual SQL Karaoke event, often considered to be the highlight of PASS. You can follow us on our social platforms like Twitter and Facebook to stay updated on daily happenings at this event. 

Check out what else we have coming up this month in our training, software and consulting departments!

Easily Handle Transform and Load of SCD2 (Type 2 Slowly Changing Dimensions)

Posted Oct 20, 2017 by Delora Bradish

This blog post is about type two slowly changing dimensions (SCD2). This is when an attribute change in row 1 results in SSIS expiring the current row and inserting a new dimension table row like this --> 

Easily Mark Deleted Source System Rows in a Data Warehouse Table

Posted Oct 17, 2017 by Delora Bradish

Even though many people think data warehouses ETLs (extract, transform and load) should contain insert data flows only, the vast majority of people I work with also have to deal with updates. Many also have to handle marking data warehouse rows as IsDeleted = "Y" in their ODS and EDW data repositories.

If you are working with a dimension table with less than 500K rows (an estimate), a traditional lookup task might work just fine. The data flow would look like this:

Read and Write to Constant Contact with SSIS Using Task Factory

Posted Oct 16, 2017 by Pragmatic Works

Manually importing and exporting data from web services can be a time-consuming task. A popular web service used today is Constant Contact for sending emails to your customers. Wouldn’t it be great to get data into or out of Constant Contact in a more automated way using SSIS?

Free POC Offer for Task Factory's Address Verification Feature!

Posted Sep 22, 2017 by Jeremy Sirois

As a consumer or potential customer, I’m often required to fill in my address details when completing a web form on various sites. The idea is this, I go from a potential lead into your database, which can then be marketed to in the form of email outreaches or physical mail campaigns where brochures or coupons are sent to my physical address.

USPS Address Verification Using Task Factory

Posted Sep 14, 2017 by Brian Knight

You’ll probably agree that one of the most valuable assets to your company is your customer database. But do you know that bad data in your client addresses can cost you thousands of dollars each year? 4.7% of ecommerce address data is undeliverable as entered by customers and 35% is undeliverable is due to undeliverable addresses. The average company loses $254 per 1,000 pieces of mail returned.

New Software Release 2017.3

Posted Aug 24, 2017 by Pragmatic Works

At Pragmatic Works, we are constantly working to enhance and update our software to make it even better. A common question from customers and developers is, when are you going to be compliant with SQL Server 2017? Well—the time is now! All our software is now compliant with SQL Server 2017!

Incorporate Information from Survey Monkey Using REST Source

Posted Jul 31, 2017 by Pragmatic Works

If you use Survey Monkey, are you looking for an easier way to get and utilize that information for your business? Survey Monkey is a great tool for getting useful information and keeping in touch with clients. At Pragmatic Works, we use it for things like post-event follow up, emails after demos for feedback and at the completion of consulting engagements.

Using SSIS REST Source to Get the Reports You Need from Litmos

Posted Jul 03, 2017 by Pragmatic Works

Pragmatic Works has done a series of blogs and videos discussing how our Task Factory REST Source can help you easily get the data you need from web services, such as Salesforce, GoToWebinar and Google Analytics. Here, we want to show how REST Source helped our Training Director, Devin Knight, with Litmos.


Blog Comments

Need help with this topic? Ask the author below.

 

Subscribe to Blog Updates