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

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?

Habilidades: Programação C#, Microsoft SQL Server , SQL, VB.NET

Veja mais: remote programming job, programming with data, programming excel spreadsheets, ms excel programming, import ms project, excel and access programming, excel access programming, excel 2016 programming, create data dictionary project oracle, job create xml import module elko data baltic, create static library project xcode access ogg video format, ssis data import relationship, create iis site script code visual basic, ssis create data extract, create invoice import csv data, create data import wizard vbnet, simple visual basic application sort excel data, jquery xml data import

Acerca do Empregador:
( 0 comentários ) mumbai, India

ID do Projeto: #10487241