Book Review by Steven Cole: Extract, Transform, and Load with SSIS

June 20, 2018
 
Do your business apps access different data sources? This book shows you how to make that task easier
As a developer, I have often worked with business applications that pull in data from various sources, such as files or databases, and send that data to multiple destinations. This sounds simple enough, but clients and/or applications typically do not send or receive data the same way. So, what happens when you must update that data for the destination to take it in? There are multiple tools you can use to modify (transform) this data—essentially, the extract, transform, and load (ETL) concept. Wouldn’t it be great to have one tool to handle multiple ETL scenarios? That’s where Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and DB2 comes into play.

The rest of this content is external, read more...

 
Return to articles