Build SSIS Package Excel file to MSSQL with validation and error output file
$30-250 AUD
Terminado
Publicado hace alrededor de 5 años
$30-250 AUD
Pagado a la entrega
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
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 en 0 día
5,0 (13 comentarios)
3,7
3,7
9 freelancers están ofertando un promedio de $259 AUD por este trabajo
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!
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
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
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
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.