The ETL Advisor Industry Notes Introducing our first issue of the ETL Advisor. Every month, we’ll focus on different topics and strategies relating to enhancing the Extract, Transform, and Load (ETL) process. This issue is all about SQL Server Integration Services (SSIS). Happy reading! SQL Server Integration Services an Introduction – Part 1 Think of it as SSIS 101. All the information you need to know about SSIS – how to create an SSIS package, and a detailed description of each its tasks, components and executables. A must read for any SSIS newbie.   Read more. How to Enrich Your Data by Extending the Power of SSIS  Bad data is a challenge for all organizations. Without data that is reliable, accurate and updated, organizations can’t deliver trusted customer, product and other vital data throughout the enterprise – resulting in waste and operational inefficiencies, less effective sales and marketing, poor customer service and potentially bad business decisions. But you can get around it.   Read More. ______Advertisement___________________________________________ Gain a Single, Accurate View of Your Customer Data Data Quality Components for SSIS is a suite of custom data transformation components for Microsoft SQL Server Integration Services (SSIS) that provide the six criteria necessary for complete Data Quality as defined by Gartner. Leverage SSIS to profile, cleanse and integrate data assets. Request a free trial: click here. ____________________________________________________________ How to Use a Basic Data Flow Task in SSIS: A Video Short Ever wondered how you can transform your data using SSIS? Brian Knight, one of the most recognized experts in the SSIS industry, demonstrates how to use the Data Flow task in SSIS – and how to aggregate and sort the data before writing the data to a flat file. Be an expert too after watching this video. Click here to view the video. About Melissa Data Corp. Melissa Data is a total solutions provider of direct mail, marketing and data quality tools. Melissa Data helps companies acquire and retain customers, validate and enhance contact data, improve marketing ROI, and save money on postage and mail processing. Since 1985, Melissa Data has helped companies like the FBI, Northrop Grumman, AAA, Safeway, and the Atlanta Braves improve customer communications. www.MelissaData.com   |    1-800-MELISSA (635.4772)    |    editor@melissadata.com

June 2011 In this Issue: Intro to SSIS Enrich Your Data with SSIS A Video Short on Data Flow Free Trials   Affordable, enterprise tools for ETL, MDM, and data governance. Download a free trial of our Data Quality Components for SSIS. Get a free trial. Get the free plug-in for Pentaho's open source ETL software to verify addresses, phone numbers, email addresses and more. Download a free trial.   Data Quality INSIDER   Subscribe to our product-specific newsletter and get tips on how to better optimize the performance of our data quality tools. More info here.   Blog Highlights Data Quality’s “True North”   Webinar Learn about record linkage in fuzzy matching now available on-demand!

Did someone forward this edition to you? Subscribe here -- it's free!
This newsletter will remain online in our web site press room for 30 days. You will always be able to read these, and all previous newsletter articles, in theAdvisor Article Library.

This Newsletter was Sent by: Melissa DATA Corp., 22382 Avenida Empresa, Rancho Santa Margarita, CA 92688-2112

Phone: 1-800-MELISSA

If you do not wish to receive future newsletters [UnSub]
Copyright 2011© Melissa DATA Corp.

Please do not reply to this newsletter