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

Category: Ssis

15 Results

How to Use the Unpivot Transform in SSIS

Posted Jul 08, 2015 by Bradley Schacht

Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be through a series of unions in T-SQL, but that’s just ugly and means lots of passes at the data potentially. You could use a T-SQL unpivot, which isn’t bad and usually my preferred method. The problem is you may not always have the option to use T-SQL.What if your source is a flat file or a database that doesn’t support unpivot?

Looping Through a Result Set with the ForEach Loop

Posted Jun 24, 2015 by Shawn Harrison

In today's blog post, I am going to show you another use for the ForEach Loop container in SSIS. Most of the time, this container is used for looping through a group of files, however, there are many different uses for it.

Azure ML, SSIS and the Modern Data Warehouse

Posted Apr 17, 2015 by Ginger Grant

Recently I was afforded the opportunity to speak at several different events, all of which I thoroughly enjoyed. I was able to speak on Azure Machine Learning first at the Arizona SQL Server Users Group meeting. I really appreciate all who attended as we had quite a crowd. Since the meeting is held practically on Arizona State University’s Tempe Campus, it was great to see a number of students attending, most likely due to Ram’s continued marketing efforts on meetup.com. After talking to him about it, I was impressed at his success at improving attendance by promoting the event on Meetup, and wonder if many SQL Server User Groups have experienced the same benefits. If you have, please let me know. Thanks Joe for taking a picture of the event too.

How to Set SSIS Encryption Level Protection within Visual Studios 2012

Posted Mar 05, 2015 by Ken Wood

You’ve just completed building your SSIS package; your hopes are set high on your newly created project becoming the company's number one tool for data building, organization and formatting. Surely that unreachable career tier level will finally be reached with the successful execution of just this one package within SSIS. You save your work and immediately execute the newly created package just to be greeted by a series of ugly error messages.

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.

Webinar Follow Up - Help, My SSIS packages need a performance tune up!

Posted Feb 04, 2015 by Tammye Michau

SSIS Performance Tuning Tips and Tricks

On Tuesday we hosted the SSIS Performance Tuning Tips and Tricks webinar with James Phillips.  He showed us how to tune up our SSIS packages to make them perform better, faster, and more efficiently. 

Through demonstrations, we were given insight on what to avoid when setting up packages.  James stated you could speed up the performance of your packages by avoiding:

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!

Employee Spotlight-Brad Schacht

Posted Jan 21, 2015 by Liz Hamilton

Since Pragmatic Works has so many amazing employees we've decided to put them in the limelight. Our employees are what make Pragmatic Works successful and we wouldn't succeed without them. Each month we will be highlighting a stellar employee that often goes above and beyond the call of duty. It's a small way we can say thanks for everything they do. 

Flashback Friday-SSIS ETL for Beginners

Posted Jan 16, 2015 by Tammye Michau

Flashback-Friday-Banner-Animated-lg

I can’t connect my package…never fear Brad Schacht to the rescue!

So you want to connect your SSIS package to Excel, SQL Server, Oracle and some Flat Files but you just can’t seem to get it to work. No worries! Our superhero consultant, Brad Schacht, will help break things down and show you how to make these connections one by one. Brad will show some of his super powers in ways that will assist you with using SSIS to do a simple data dump, how to keep tables in sync, and how to do incremental loads. 

Naughty or Nice? Be Nice & Help Us Support Seamark Ranch!

Posted Dec 22, 2014 by Brian Knight

Promo Code: NEWYEAR

Pragmatic Works is offering $200 off any virtual training class purchased by January 15, 2015 when you use the promo code NEWYEAR at checkout. Additionally, if you book your virtual training class by December 31, 2014, Pragmatic Works will donate $50 to Seamark Ranch for every class puchased.

Subscribe to Blog Updates