Find Jobs
Hire Freelancers

Importing CSV data into Microsoft SQL SERVER 2008 R Express

$10-30 USD

Terminado
Publicado hace casi 4 años

$10-30 USD

Pagado a la entrega
If you are a specialist in importing large databases into SQL, you know how to deal with errors when importing large databases and you are also very good at creating SQL queries, this job is for you. Objectives to be achieved: a) Import 3 tables in CSV format to SQL file (I tried to import using the import wizard, but I couldn't finish the import, it presented errors 0xc02020a1, xc020902a, 0xc0202092, 0xc0047038) b) Adjust so that all tables use the same primary key c) Reduce the database based on criteria and generate new reduced tables You can use your own server to do steps A, B and C above or you can use my server (Windows server 2008 R2 with SQL SERVER 2008 R2 EXPRESS). In the end I need to have on my server all the imported tables and also the reduced tables. If you are an expert, you will not spend more than 1 hour of work. If you are not an expert, do not bid.
ID del proyecto: 26167903

Información sobre el proyecto

33 propuestas
Proyecto remoto
Activo hace 4 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
Adjudicado a:
Avatar del usuario
Hi, When I read the job description, I immediately thought I can do this job. I have 15+ years in the database field. As a DBA, I have installed and configured SQL Server and hardening MSSQL. I have experience in ETL processes where import and export data on SQL Server. I can help you to import the cvs files into your SQL Server DB, create the index and create subqueries that create new tables. Thank you for your time to review my proposal and I'm excited to work together soon
$30 USD en 1 día
5,0 (8 comentarios)
4,1
4,1
Avatar del usuario
-- Expert is here ------------ 20 Years SQL Server database Expert --- Yes i can finish your 3 point within hours --- CSV import to Sql server the error you noticed also will solve --- i am expert this import ---thank you
$30 USD en 1 día
4,9 (11 comentarios)
4,7
4,7
Avatar del usuario
Please message me to start your work. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 10.6 years experience in MS SQL Server, MySQL and 7.8 years experience in SSRS, SSIS (Import / Export). Please let me know more details and when we will start. Sky pe jikenjd
$30 USD en 1 día
5,0 (23 comentarios)
4,2
4,2
33 freelancers están ofertando un promedio de $28 USD por este trabajo
Avatar del usuario
Hello! I am a Data Engineer, MS SQL certified MCSA / MCSE, with 14 years of experience writing SQL queries, reports/dashboards design and construction, database migrations, data warehousing, and database related projects and tasks. I am a near-native English speaker, currently available, business-savvy, and results-oriented. I can work on your requirement on my premises. You can send me the CSV files and the business rules, and I will send you the database so you can restore it on your premises. I have all the software and the tech skills required to do the job. We can discuss details over chat if you need. Thanks! Sergio
$40 USD en 1 día
4,9 (22 comentarios)
5,7
5,7
Avatar del usuario
Hi There, Does you CSV contains escape characters like , ' with in the record? What is the CSV size? Regards, Shobhit Pundir
$50 USD en 7 días
4,9 (12 comentarios)
5,2
5,2
Avatar del usuario
Hi, I am ready to work on your project to import your files from csv files into ms sql server. I have experience in MS SQL server, asp.net, crystal reports and VB.net more than 12 years. Other skills: Access vba, Excel vba, C#, my sql , technical & Sage 300 (ACCPAC) ERP support, SQL server Replication, Microsoft office(Word, Excel, PowerPoint, Access), Windows servers. Best Regards. Khaled Alflah
$30 USD en 2 días
5,0 (15 comentarios)
4,9
4,9
Avatar del usuario
I have more than 15 years of experience in SQL Server database design, modelling, development and Administration. I have worked for database designing and modelling of complex business requirements at efficient way. I have very good experience in TSql, writing complex scripts, complex stored procedures, functions, triggers etc. I am good with performance tuning which includes Index and its usages, JOINS, dynamic queries, CTE, Temp tables, Table variable and all its usages.   I am also good and working with big clients for BI part like SSIS, SSRS and SSAS. Created different workflow PACKAGES and reports for clients. I also involved in Data warehouse design form OLTP systems.    I have worked with medium to large mission critical databases. Worked as DBA for 24*7 support environment. Involved in activities like Performance monitoring, Log file maintenance, deadlocks and blocking handling, disk space management, Job monitoring and failure handling, Backup and recovery process for disaster management.   I am looking for long term stable remote work and good client with not only work but good values also. I can work in any time zone and join immediately. You can check my profile.
$56 USD en 1 día
5,0 (5 comentarios)
3,3
3,3
Avatar del usuario
Hi, I am a c# developer for past 6+ years, Have developed many C# windows and web Application(Asp.net ,MVC, Enity framework). Also have been worked with fortune companies and received appreciation. Have experience in javascript, jquery, Angularjs etc., Also have experence in SQL,SSIS package., have written lot queries for large size database
$30 USD en 1 día
5,0 (3 comentarios)
3,0
3,0
Avatar del usuario
Hi I am working from 8 years in sql server and services as back end. On back end- Worked with sql server from version sql 2008 r2 to 2017. I am involved in data migration, clustering, always on, stored procedure, views, schema, table , query performance and other activities. I have worked with central and state government projects having one lacs users around and 10 stake holders. worked with database of 1 tb and millions of rows in a table. So worked in query performance, sql profiler also. I would like to go through in details about the project. Regards
$12 USD en 7 días
5,0 (6 comentarios)
2,4
2,4
Avatar del usuario
Hi There, I am Solution Architect with 12+ years experience of C# desktop applications, SharePoint and ASP.NET Applications WCF and Rest API. I'm expert expert with sql server ... it's my first bid after 9 years away from freelance so please let me show you my skills.. Please message me for the details.
$30 USD en 1 día
5,0 (1 comentario)
1,2
1,2
Avatar del usuario
Hello Sir, My name is Mohamed Nashaat and I am a professional Certified EMC Data Engineer I have read your Description and I am confident I can make it to you
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi there , I have read the brief details on the job listing . You can check my experience , customer feed back I believe its a doable job I have great experience doing projects with SQL server, C# , Asp,WPF,Windows App Development . Please initiate the chat so we could discuss it in detail . Thanks .
$20 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am an expert solution architecture with 11 years of experience in asp.net development and Sql server database. I can easily import files to your database just contact me for further discussion.
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have 10+ years Working Experience as a Database/System/Network Administration, Good command on Office Automation Software, Supervise many projects of Data entry, Data Mining, Dumping and rearrangement. Very loyal and hard-worker with tasks given by the source............... I have Migrated (Billions of Records) Historical Records from different data sets, from Manual (Excel,CSVs,XML,text)to Automated and from old structured DBs (mySQL4.0/5.0, SQL7.0/2000, to 2012 R2...) to New Data Base platforms. I here by offer my services for this project and shall be very thanks full to you if you consider my services for this work. Regards
$23 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have more than 10 years of experience in SQL Server database and software development. If any kind of error occurred, i will write windows application for it.
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
hey I have 6+ years of experience in SQL server database administration and warehouse designing by combining the data from different sources. I believe the task you mentioned were useful. please initiate the chat so that we can discuss more about this.
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, Having more than 15 years of experience in developing, training and implementing .NET, MVC with MSBI, SQL Server applications and HTML5, Bootstrap, JQuery, JavaScript, AngularJS with UML, I will be able to provide you the solution using SSIS Kindly check my profile for further details of my projects. I request you to kindly ping me and have the discussion and select me for the work, and I guarantee you that you will not be sorry for that. Regards, Raj
$10 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
SQL data admin, so that I can understand the problem and let's import and find a solution to it
$25 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have the licensed Informatica tool.I am expert in handling all the Semi-Structured and structured Data (.xml,.csv,etc..)Please share your server details on which the data to be imported to. I can do this in couple of hours and give it to you. No Duplication of Work will be needed. Please message me and let's work together and complete the task. Even this can be achieved with SSIS a free ware. I am expertise in both. Thanks
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I will write a console Application with robust logging which will give you in detail logs of which data got Uploaded and which got failed with the error of failure. this is very common task back at my workplace. just wrote a similar utility for big advertisements firm to move their total 2TB of Data. This approach may take comparatively more time than other approaches but it is best for handling and processing compromised (with errors) data back to SQL server again. If you having such data i am your best choice.
$30 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
• Having 2+ years of experience into Analytics, Predictive Modelling & Business Intelligence/Analysis and 2+ year in DWH development and testing. • Hands-on Experience in Python model building • Have knowledge in Hive and big data concepts • Strong SQL knowledge • Hands-on experience in building pricing risk models for clients working in Insurance domain. • Developed algorithms to identify the latent characteristics of the customers for taking channelized strategic decisions for much more effective business successes. • Experience in designing & developing end-to-end Big Data integrated solutions for different verticals to cater to the client’s analytical business problems. • Having experience on Regression, Logistic, Decision tree, Random Forest, Cluster and MBA algorithms • Having experience on time series analysis • Having work experience on Tableau and Business object reporting tools
$20 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi my name is Shafik and i a developer with more than 15 years experience. have high skills in Microsoft technologies especially ASP.Net / MVC with C#. able to deal with complex ms sql queries,stored procedures,functions and views. experience with html, css and javascript. precision in work. Ability to deal with exist code I Believe that i can do the job perfectly, Thank you for your time and consideration. Sincerely, less
$40 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I work in multinational company as a senior project manager and I do similar task very frequently Relevant Skills and Experience vBA, SQL, database and Excel
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de BRAZIL
sorocaba, Brazil
5,0
10
Forma de pago verificada
Miembro desde sept 15, 2010

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.