THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Jorg Klein

Microsoft Data Platform MVP from the Netherlands

Replication Services as ETL extraction tool

You can read this blog post at this link: https://jorgklein.com/2011/03/02/replication-services-as-etl-extraction-tool

This blog has moved to www.jorgklein.com There will be no further posts on sqlblog.com. Please update your feeds accordingly.

You can follow me on twitter: http://twitter.com/jorg__klein

Published Saturday, March 12, 2011 11:42 AM by jorg

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Marlene said:

Hi

I am trying to get your SSIS package, but somehow i am stupid, and can not see the design and go into the steps of your Extract.dtsx.

How can i get to the design of it?

Thanks!

marlene

March 31, 2011 3:36 AM
 

jorg said:

Hi Marlene,

I have just checked the package again and I can open it and see the design without problems. Please note that it's a SSIS 2008 package so you wont be able to open it in SSIS 2005!

--Jorg

March 31, 2011 6:51 AM
 

Scrape Web Pages said:

Hi,

I like this site. Keep it working every day.

September 27, 2011 12:48 AM
 

Aniket said:

Hi Jorg,

Nice blog. I have a Source system which is providing Real time production data on the equipments at the Mine. Some tables are unloaded and loaded again, some tables are updated , some table deleted a slot and reloads. I am using T-SQL to bring the data from these tables to a staging area. For such a scenario which replication should I use as I am copying the exact same data of the source to the stage. Currently I employ methods to check latest timestamp record at staging and bring from source only those records which are greater than timestamp. Also for code table I use "truncate insert into " mechanism.

Please advise me on this

November 6, 2011 2:15 AM
 

Daniel said:

I like the post very much!

Could you tell something about the performance when using an Oracle source? (Keeping in mind the Oracle Connector by Attunity with it's blazing performance!)

December 30, 2011 12:18 PM
 

Karthik Vadla said:

Hi Jorg,

I have downloaded the SSIS package, but not able to view the design. Can you please provide me .dtsx package with design.

Thanks

Karthik Vadla

December 18, 2012 4:13 AM
 

ssc said:

can you please share the sample ssis package for the above.

Thanks in advance...

August 11, 2014 7:18 AM

Leave a Comment

(required) 
(required) 
Submit

About jorg

Jorg Klein, Microsoft Data Platform MVP from the Netherlands.
Privacy Statement