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?
Category: Ssis15 Results
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.
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.
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.
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:
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!
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.
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.
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.