Build SSIS Package Excel file to MSSQL with validation and error output file

$30-250 AUD

Imekamilika

Imechapishwa

over 5 years ago

$30-250 AUD

Kulipwa wakati wa kufikishwa

I get about 50 excel files periodically over a quarter and need to get them into a MSSQL Database. The MSSQL database has dimension tables (CCY, Country, Sector, Asset, Fund ect...). The MSSQL database has a FACT table where I would like the data stored I'm happy with this structure. ---------------- TASK ---------------- I need a freelancer to create a process to take an excel file and only insert validated correct data into my FACT table. Bad data must be somehow flagged as at the end I want a file generated (potentially with error messages). ---------------- My Idea ---------------- I thought the flow an SSIS package may look like this, but i maybe wrong 1) Take data from the excel file 2) Load into a staging table in database 2) Somehow validate the data with the Dimension Tables, maybe using SSIS or StoredProc (freelancer to write) 3) Load/Insert Correct Data (into the fact table) 4) Generate file with bad data - maybe including error message ---------------- Notes ---------------- I want to use MSSQL Database & SSIS You can change whatever you like but I want efficiency and integrity of database kept I have my database scripts ready to send The freelancer can create any additional tables or stored procedures in the database as they wish. The freelancer may with use a staging table in the database if they want I have an excel example file ready to send, it is an extract. Files could be up to 1,000 lines – but they may quickly get bigger so I’m looking for the most efficient method possible Thanks

SSIS (SQL Server Integration Services)

Kitambulisho cha mradi: 18557788

Kuhusu mradi

9 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@vw7590795vw

Please message me. Send sample excel files and MSSQL DB design scripts Let me know different validations and sample output file. So, I can start immediately after review all your requirements and award me project with milestone. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 9.2 years experience in MS SQL Server and 6.4 years experience in SSRS, SSIS (Import / Export). Please let me know more details and when we will start. Sky pe jikenjd

$200 AUD ndani ya siku 0

5.0

(13 hakiki)

3.7

9 wafanyakazi huru wana zabuni kwa wastani $259 AUD kwa kazi hii

@tiaratechies

Hello, The excel file data will be placed in to the required columns in a less time as we have a clear understanding of the functionality.

$500 AUD ndani ya siku 3

5.0

(18 hakiki)

5.0

@FreelancerTechX

Hello, I think a custom application (.NET) may be more suitable for this task ********************************

$250 AUD ndani ya siku 5

5.0

(2 hakiki)

2.8

@IntrinsecoTImx

Hi there! We are mssql experts, we can easily help you creating the scripts for load the data into the fact table you mentioned, of course right after a validation process. Please ping me for more details. Thanks! Best regards!

$250 AUD ndani ya siku 3

5.0

(1 hakiki)

2.9

@naveenrgowdackm

I have created similar ETL Framework to handle the excel data load to Data warehouse server. I Can create a Validation process to check the quality of the data and send mail to the concerned person I can demonstrate the package i have developed

$146 AUD ndani ya siku 3

5.0

(2 hakiki)

2.0

@nagamallesuuarao

Software professional having 15 years of experience especially in the areas of Data warehousing and having expertise in Business Intelligence tools like SSIS, SSRS, SSAS and Tableau. Delivered more than 30 enterprise level projects with 100% quality output

$333 AUD ndani ya siku 5

0.0

(0 hakiki)

0.0

@anusha07505

Please provide the details as to work on remote or can create package is enough. Direct loading or have to perform transformations if so structure of fact table Relevant Skills and Experience 4 years of experience

$155 AUD ndani ya siku 3

0.0

(0 hakiki)

0.0

@michmang

We need to scatch your idea into a flow to clarify the process and discuss missing or bad quality data? When agreed upon then we proceed. End result would be a relational database with full integrity.

$166 AUD ndani ya siku 3