Find Jobs
Hire Freelancers

CSV data import into SQL server - including typecasting

$30-250 USD

Cerrado
Publicado hace más de 8 años

$30-250 USD

Pagado a la entrega
I need SQL sp that will add a csv file containing data to an existing database containing previous imports. The imported data should be typecasted into the desired types (numerical,float, date, time etc). These are 40 fields. After import another 5 fields might need to calculated from the previously imported fields (muliplications)
ID del proyecto: 8642019

Información sobre el proyecto

46 propuestas
Proyecto remoto
Activo hace 8 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
46 freelancers are bidding on average $129 USD for this job
Avatar del usuario
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 6+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net,Asp.net MVC - Linq to SQL,Entity Framework - Javascript,Jquery,KnockoutJS,AngularJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Facebook Graph API - Application Security Remediation - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are asking for. We can discuss further on chat(Skype:mahajan344). Looking forward from your end. Thanks Nikhil Mahajan
$77 USD en 1 día
4,8 (40 comentarios)
5,9
5,9
Avatar del usuario
A proposal has not yet been provided
$111 USD en 1 día
4,7 (35 comentarios)
4,8
4,8
Avatar del usuario
I can do your job please hire me
$222 USD en 3 días
4,5 (26 comentarios)
5,2
5,2
Avatar del usuario
Hi myself expert in dot net and sql server with 10 yrs of experience in software development. let me know your requirement in details.. Payment terms: 1. 30% release on awarding the project. 2. 40% release on UAT 3. 20% rlease on Uat Sign off 4. 10% release on project completion and source code handover. awaiting for your positive reply. thanks and regards..
$100 USD en 3 días
4,5 (9 comentarios)
4,6
4,6
Avatar del usuario
I'm a very experienced and active BI developer, especialized on Microsoft tools, but also working with Oracle and Sybase databases. Also experienced working with Hadoop and Hive, migrating a traditional DW to Big Data project to improve the performance of the processing, based on Azure tools and HDInsight. I've been working with SQL language for 6+ years, creating complex queries for reporting purposes and data management.
$155 USD en 3 días
5,0 (1 comentario)
4,3
4,3
Avatar del usuario
I look forward to discuss further about the project details and deliver the same to your needs .
$147 USD en 3 días
5,0 (3 comentarios)
3,7
3,7
Avatar del usuario
Aucune proposition n'a encore été fournie.
$155 USD en 3 días
5,0 (6 comentarios)
3,5
3,5
Avatar del usuario
We will deliver you in less time with quality for sure.
$111 USD en 2 días
4,8 (12 comentarios)
3,9
3,9
Avatar del usuario
I have 3+ years expertise developing software by .NET and SQL SERVER. I can help you finish this project with the best quality.
$150 USD en 4 días
4,6 (4 comentarios)
3,2
3,2
Avatar del usuario
I have 8 years of experience in SQL and SSIS, i should be able to do this task using SQL and SSIS, pleaselet me know if you are interested.
$72 USD en 2 días
5,0 (4 comentarios)
3,2
3,2
Avatar del usuario
I am the VB6.0/Dot Net Professional Developer/ SQL Server developer. My professional experience includes extensive hands on expertise on Microsoft technologies.I understand how to build project that directly meet user requirements end to end, user friendly and affordable. I also understand the importance of building strong projects that stand up to the high performance and high volume environment. We are really much interested to work with you for long term relationship, please pm me for more discussion, i would like to request you please provide me your project SRS.i will provide you work as you want ,please pm me for more discussion
$200 USD en 5 días
5,0 (5 comentarios)
2,9
2,9
Avatar del usuario
Can you please tell me what SQL server you are using? MSSQL, MySQL, noSQL or Oracle? The syntax of the stored proc will change depending on the server. Also, will the CSV file be stored on the same local machine that the SQL server will be installed on? There are limitation depending on the server whether it can access networked files. Can you provide a schema for the existing database/tables and the sample CSV file? I can provide the script for you within a day once I have the answers to the above questions.
$222 USD en 1 día
5,0 (1 comentario)
2,7
2,7
Avatar del usuario
Hi, I have worked on number of imports and exports of this kind, I have good experience in importing and exporting data from CSV files into SQL Server. I understand that you need to import and load CSV into an existing data table and format the data types as per the underlying table definition. I can do this CSV import via 1) SQL stored procedure 2) or SQL script 3) or can automate this using SSIS package or import export wizard Please don't hesitate to contact me anytime and Kindly let me know if you need any further information about my approach. Thanks
$49 USD en 2 días
3,7 (2 comentarios)
2,7
2,7
Avatar del usuario
Over 15 years of experience in Microsoft Technologies. MCTS (Microsoft Certified Technology Specialist) on Web Applications Development with Microsoft .NET Framework 4 (Exam Code: 070-515). Functional experience includes Telecom Application, Financial Application, ERP-Application, School Application and development of user interface elements for embedded software. Having good knowledge and skills in OOPS (Object Oriented Programming), ASP.net with C# & VB, Web services (SOAP, WSDL), WCF, WPF, MVC, Entity Framework, Visual Basic, Crystal Report, SSIS & SSRS, MS SQL Server, Oracle and MS Access. Experience in working VS2012, VS2013 and VS2014 with AngularJS, Knockoutjs, Bootstrap css Telerik Controls etc all advanced technologies. Having experience in MEAN Stack (MongoDB, Express JS, Angular JS, Node JS). I have a ready made code for it and can quickly deliver with few tweaks only. Very committed to deliver products matching with requirements on or before time. I will develop and give demonstration frequently to match your expectations. For any clarifications, contact me.
$155 USD en 3 días
4,4 (2 comentarios)
2,2
2,2
Avatar del usuario
A proposal has not yet been provided
$137 USD en 3 días
5,0 (1 comentario)
0,6
0,6
Avatar del usuario
Hi, We are a team of 4 BI professionals each having experience more than 6 years. This work of yours can't be done using SP only, it require us to create a SSIS package which will load CSV file data into existing table in the required database after applying data transformation (data type change). We can also create a sql job for this piece of work so that file will be automatically picked and data will be loaded into the database. We can insert error message in a error table as well if you wanted without adding extra cost. We are professionals in this field and can add extra features if you want. We can do this work of yours within a day. We can send you screenshot of existing work done by us if you wanted. Looking forward to hear from you.
$60 USD en 1 día
5,0 (1 comentario)
0,3
0,3
Avatar del usuario
A proposal has not yet been provided
$111 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Specific Database oriented experience and skills. Like i can deal with SSRS, SSIS, SSAS, XML and almost may tasks from administration side like replication, backups, monitoring, logs optimization.
$150 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$222 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have more than 5 years of experience in software development. Over these years, I developed many successful applications both on the web & Windows. Having strong knowledge in Database.
$50 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de INDIA
India
0,0
0
Miembro desde oct 8, 2015

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.