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

Completado Publicado hace 7 años Pagado a la entrega
Completado Pagado a la entrega

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?

Programación en C# Servidor de Microsoft SQL SQL VB.NET

Nº del proyecto: #10468893

Sobre el proyecto

34 propuestas Proyecto remoto Activo hace 7 años

Adjudicado a:

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 Más

$160 USD en 2 días
(147 comentarios)
6.5

34 freelancers están ofertando un promedio de $190 por este trabajo

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 en 3 días
(95 comentarios)
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 Más

$225 USD en 3 días
(148 comentarios)
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 Más

$250 USD en 5 días
(52 comentarios)
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 Más

$250 USD en 5 días
(31 comentarios)
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 Más

$155 USD en 3 días
(12 comentarios)
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 Más

$111 USD en 3 días
(67 comentarios)
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 Más

$263 USD en 6 días
(27 comentarios)
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 en 10 días
(19 comentarios)
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 Más

$155 USD en 3 días
(18 comentarios)
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 Más

$100 USD en 3 días
(14 comentarios)
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 Más

$150 USD en 2 días
(20 comentarios)
4.2
vinaysinghh

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

$55 USD en 3 días
(16 comentarios)
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 Más

$155 USD en 3 días
(22 comentarios)
4.4
aramgz

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

$500 USD en 5 días
(3 comentarios)
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, Más

$222 USD en 7 días
(5 comentarios)
3.2
ankita0389

A proposal has not yet been provided

$222 USD en 7 días
(2 comentarios)
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 Más

$255 USD en 3 días
(1 comentario)
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 Más

$111 USD en 3 días
(2 comentarios)
2.0
Rajib143

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

$144 USD en 3 días
(2 comentarios)
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 Más

$166 USD en 7 días
(2 comentarios)
1.2