Find Jobs
Hire Freelancers

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
ID del proyecto: 18557788

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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
Avatar del usuario
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 en 3 días
5,0 (18 comentarios)
5,0
5,0
Avatar del usuario
Hello, I think a custom application (.NET) may be more suitable for this task ********************************
$250 AUD en 5 días
5,0 (2 comentarios)
2,8
2,8
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
2,9
2,9
Avatar del usuario
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 en 3 días
5,0 (2 comentarios)
2,0
2,0
Avatar del usuario
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 en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
GLEN IRIS, Australia
0,0
0
Forma de pago verificada
Miembro desde ene 19, 2019

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.