MSSQL Data Import Project, create SSIS or Other Process to import Spreadsheets

Ukończone Opublikowano 7 lat temu Płatność przy odbiorze
Ukończone Płatność przy odbiorze

The task would be to create a task in SSIS or any method for importing Excel Spreadsheets. The spreadsheets have the same number of columns and the first 5 rows are skipped. I have a couple of sample files. The worksheet tab on the spreadsheets are not named the same but there is only one tab in each file. This job could be scheduled to run daily as to import new files when they are added to the Import Path. The task that I am asking you to bid on is 1) examine spreadsheet files 2)create schema based on columns 3)write import script for database 4)provide a simple front end for searching the database I will provide remote access to an MS SQL 2014 server with SSIS and Data Tools installed (Visual Basic 2015), The sample files will be located on this server for import. They are not very large (column A through W) but there are many of them which should not matter. Do you have any additional questions before bidding?

Programowanie w C# Microsoft SQL Serwer SQL VB.NET

Numer ID Projektu: #10468893

O projekcie

34 ofert Zdalny projekt Aktywny 7 lat temu

Przyznany użytkownikowi:

sumon355

Hello, I am very much interested to do this as i have strong experience doing these kind of works by .Net. I would like to do this automated import from excel to sql server by .Net console application which would be p Więcej

$160 USD w ciągu 2 dni
(147 ocen)
6.5

34 freelancerów złożyło ofertę za $190 w tym projekcie

riskypathak

Well I have understood it but still want to know that how many columns are there in spreadsheet/table and is it to import into a single table or multitable. Thanks

$315 USD w ciągu 3 dni
(95 Oceny)
7.0
customizedata

Is it necessary to use SSIS ? I can make an executable in .net 1- It will have a browse button to specify the default location for excel files. 2-It will create a scheduled task in windows that will do the import Więcej

$225 USD w ciągu 3 dni
(148 Oceny)
6.7
kalpesh2804

Hello, I have 10 years of experience in C#, Vb.Net, MSSQL, MySQL, SQLite, Visual FoxPro 9. I can import data from Spreadsheet to MSSQL. I will provide C# script you can add it in scheduler and also configure moni Więcej

$250 USD w ciągu 5 dni
(52 Oceny)
6.4
XeeChaun

hi. I've 3+ years of experience in C#. I've already worked with SSIS script tasks and done similar projects in the past. here's the link to last one completed: ---(https://www.freelancer.com/projects/Software-Architect Więcej

$250 USD w ciągu 5 dni
(31 Oceny)
5.8
akhila27

Hello, Before you select a part time developer from here, take a look at our portfolio: fugacode.com. If you like what you see, contact us. That's all. "Why hire part time college students? when you can hire prof Więcej

$155 USD w ciągu 3 dni
(12 Oceny)
5.5
marasinghe82

Dear Sir, Please send me sample file I can work offline and get back to you. I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last nine years I involved many project in ETL, data wareho Więcej

$111 USD w ciągu 3 dni
(67 Oceny)
5.6
puneetjaini

Hi, I'm proficient in Wordpress, Sql, Html, Css and Php and can do this job efficiently. I have over 18 years of experience in developing website's, done more than 2000 projects successfully on this site itself with 9 Więcej

$263 USD w ciągu 6 dni
(27 Oceny)
5.5
sergioeliot3

Hi! I can help you to create an import proces for your Spreadsheets. Please let me know if interested, Best regards, Eliot

$98 USD w ciągu 10 dni
(19 Oceny)
4.3
rommykumar01

I am a full time freelancer with over 4 years of experience in Asp.Net, C# and Sql Server, designed and developed 20+ web applications and desktop application using C#, Asp.net, MS Sql Server, MS Access, SSRS, MS Repor Więcej

$155 USD w ciągu 3 dni
(18 Oceny)
4.5
saimyousaf

I'm CS Graduate. I'have quite great skills in database. I have studied detailed courses of Databases, Data WareHoursing, Data Mining and Advanced Databases. You can find me very helpful resource for your project. I h Więcej

$100 USD w ciągu 3 dni
(14 Oceny)
4.1
ashupathania

I have 5 + years of experience in MSBI Technology (SQL Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Worked on various types of ER diagram Więcej

$150 USD w ciągu 2 dni
(20 Oceny)
4.2
vinaysinghh

I am ms sql server dba having more then 6 yrs of experience . I can do this task easily ............................................................................................

$55 USD w ciągu 3 dni
(16 Oceny)
4.2
nikmah344

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 7+ years of experience in Web Development. I have worked on below technologie Więcej

$155 USD w ciągu 3 dni
(22 Oceny)
4.4
aramgz

I've experience in automation of data import from excel to mssql

$500 USD w ciągu 5 dni
(3 Oceny)
3.4
shahzaib121

Hi Dear I have a lot of experience in , DataBases +Data Warehous, Job Automation etc.I am DataBases + Warehouse certified from Oracle. I have done many work in Requirments analysis , Data Staging, Data Warehouse, Więcej

$222 USD w ciągu 7 dni
(5 Oceny)
3.2
ankita0389

A proposal has not yet been provided

$222 USD w ciągu 7 dni
(2 Oceny)
2.8
thampl

Hi there, I'm Tom and I'm interested in this job. I have 9 years experience with MSSQL server including SSIS. How many different files you have ? Files are CSV ? and what is delimiter ? When files are import Więcej

$255 USD w ciągu 3 dni
(1 Ocena)
2.7
joshuaburns

Hi, In my current Professional Microsoft SQL Server DBA role, I have extensive experience with SQL Server versions 2000-2016. In my Professional experience, I have developed an FTP process, which extracts data from Więcej

$111 USD w ciągu 3 dni
(2 Oceny)
2.0
Rajib143

I saw your requirement . I can do that I have 3+ years exp .I am ready to work .

$144 USD w ciągu 3 dni
(2 Oceny)
1.6
patmilimilind

Hi, I am B.Sc. graduate .Since 5 years working as a SQL DBA in Mumbai based datacenter. Also have 9 years of experience in VB.NET. I am confident of completing your work. Have some queries that to be discussed b Więcej

$166 USD w ciągu 7 dni
(2 Oceny)
1.2