SSIS Compare data in 3 tables

$30-250 USD

Kapalı

İlan edilme:

yaklaşık 2 yıl önce

$30-250 USD

Teslimde ödenir

I have a database that has 3 tables. Each table has exactly the same columns (90 columns). The tables all have the same primary key that consists of 3 columns which make the rows unique. The SSIS package needs to read row 1 in table 1 (all columns) and then read table 2, It needs to compare values from table 2 to table 1. If differences are found, a text file must be written out. It must do that for 4 million rows in the tables. The same process as above should follow (read table 1) and compare to table 3.

Microsoft SQL Server

SSIS (SQL Server Integration Services)

Proje No: 33361541

Proje hakkında

10 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 2 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

10 freelancer bu proje için ortalama $189 USD teklif veriyor

@Truonggiang86

Hello there, to do this problem first we can write a store procedure to identify the difference using checksum function, if we found the different rows and we will write out to csv or some output. Pls share me your tables so we can discuss. Waiting for your response if interested. Thank you!!!

$180 USD 2 gün içinde

5,0

(28 değerlendirme)

5,6

@Bhatti1987

Hi, I am avaliable and can start right now...and complete in max 01 day.. I have understood your requirements. I have already done these type of project with my own SQL custom base CDC inform of procedure, SSIS packages and procedure to complete assigned task...and this custom SSIS and procedure will continously perform the required tasks. I have total 11 plus years of experience especially in Development, DWH, ETL, SSIS, SQA, Database development & maintenance. • Very strong in Open Interfaces, SQL, PL/SQL, Stored procedures/packages, writing Test Scripts, Windows/Linux environment and both back-end database development and front-end development. Business Intelligence & ETL consultant with sound experience in end to end BI implementation. Sound experience in logical & physical modeling of semantic layer, reports and dashboard development in various BI tools like MicroStrategy, Microsoft Excel, Tableau, Power BI. Developed Powerful ETL Using PDI (Pentaho Data Integration). Good knowledge of Big Data Analytic s having worked and successfully delivered on Sentiment prediction of Social Data set. • Business Analysis and Requirement Gathering • Effort Estimation and Planning • Solution Design and Architecture • Logical and Physical Data Modeling (Semantic & Core) • Reports and Dashboard Design and Development • Advance Analytics and Big Data…

$100 USD 1 gün içinde

4,9

(10 değerlendirme)

2,8

@Asad9916

Hi I'm professional Database developer and Administrator. I've an experience almost 6 years in this field. I'm expert in SSIS. Feel free to contact me. Lets discuss further. Thanks

$180 USD 1 gün içinde

4,6

(6 değerlendirme)

3,2

@alexsuarez

Having used SQL Server and SSIS for over 20 years I’m very familiar with the platform and the problem you are looking to solve.

$500 USD 7 gün içinde

5,0

(1 değerlendirme)

2,2

@aboujbel05

Hi dear I read your request and I can do it I have more than 3 years experience in Management SQL Server i have done several projects I will be glad if you talk to me, thank you

$160 USD 7 gün içinde

0,0

(0 değerlendirme)

0,0

@henokflk

I'm well experienced in database design of all the top flavors (Oracle, MSSQL, MySQL) and providing a well performing database design in different developments. Catch me over chat or message me and we can have a detailed talk. Deliver with quality.

$180 USD 3 gün içinde