Find Jobs
Hire Freelancers

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

$30-250 AUD

완료함
게시됨 약 5년 전

$30-250 AUD

제출할때 지불됩니다
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: 18557788

프로젝트 정보

9 제안서
원격근무 프로젝트
활동 중 5년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
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 0일에
5.0 (13 건의 리뷰)
3.7
3.7
9 이 프로젝트에 프리랜서들의 평균 입찰은 $259 AUD입니다.
사용자 아바타
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 3일에
5.0 (18 건의 리뷰)
5.0
5.0
사용자 아바타
Hello, I think a custom application (.NET) may be more suitable for this task ********************************
$250 AUD 5일에
5.0 (2 건의 리뷰)
2.8
2.8
사용자 아바타
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 3일에
5.0 (1 건의 리뷰)
2.9
2.9
사용자 아바타
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 3일에
5.0 (2 건의 리뷰)
2.0
2.0
사용자 아바타
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 5일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
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 3일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (AUSTRALIA)
GLEN IRIS, Australia
0.0
0
결제 수단 확인
1월 19, 2019부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.