Blogs
Welcome to blogs.conchango.com Sign in | Join | Help

Welcome to blogs.conchango.com

SSIS Junkie

SSIS: The new ETL Paradigm

This is just a short note with a link to a new article of mine that has just been published on SQLServerCentral.com. The article is an attempt to explain to existing DTS developers the most fundamental change that they will have to cope with when moving to SQL Server Integration Services (SSIS); that being the seperation of data movement from workflow control. If you have an interest in SSIS please take the time to read through it and let me have some feedback be it good or bad.

-Jamie

Published 15 February 2005 08:35 by jamie.thomson

Comments

 

TrackBack said:

Another SSIS article from our good friend Jamie...
February 15, 2005 16:25
 

TrackBack said:

April 3, 2005 11:49
 

TrackBack said:

April 3, 2005 11:49
 

Mag said:

I just wanted to get some feed back from Jamie about performance in Integration Servies. I've been using it for two months and I have created a package that should pump 2.5 million records from my source to my destination. Now I will say that I have several steps of sorting (Using the sort component) and merge join (using the merge join component). But my performance is horrible. I used the methodology outlined in your Article: " New ETL Paradigm" I saw this component from ivolva.com which they created as a third party component called extra sort. It says it speeks up sorting. Do you have Any suggestions???
September 23, 2005 18:47
 

Silvia said:

Thank you for the info!
November 2, 2005 14:27
New Comments to this post are disabled

This Blog

Syndication
EMC2, EMC, and where information lives are registered trademarks of EMC Corporation.
All other trademarks used herein are the property of their respective owners.                  
© Copyright 2009 EMC Corporation. All rights reserved.                                                    
Powered by Community Server (Personal Edition), by Telligent Systems