The ETL Advisor
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.
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.
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:
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
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
In this Issue:
Intro to SSIS
Enrich Your Data with SSIS
A Video Short on Data Flow
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.
Data Quality’s “True North”
Learn about record linkage
in fuzzy matching now available
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
If you do not wish to receive future newsletters
Melissa DATA Corp.
Please do not reply to this