Find Jobs
Hire Freelancers

Import complicated Text file into SQL Database

$30-250 USD

Suoritettu
Julkaistu yli 5 vuotta sitten

$30-250 USD

Maksettu toimituksen yhteydessä
Hello. We potentially will be receiving a file in this format each day that I need to import into an SQL database. The formatting of the text file data is unfamiliar to me and I am currently unable to get it into SQL. The database can be created with whichever fields are necessary to receive the data (I assume columns should be Code Description Blocks Lots DetailLevel Arbs NoBlocks NoLots Sub_Comments Sub_Close_Flag Close_Flags Close_Comments). Preferrably I'm looking for an SQL Script I can run each day to import this data file without going through a bunch of DTS Import wizard steps. Please take a look at the attached file before bidding. Thanks!
Projektin tunnus (ID): 18502811

Tietoa projektista

34 ehdotukset
Etäprojekti
Aktiivinen 5 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
Hello, As an expert in MS SQL Server, i am very much interested to do this task. I saw your attached file, in fact i would prefer to provide you an application for this purpose. You will be able to use in in windows task scheduler or sql job agent to run in an interval regularly. Please let me know if you are interested. Thanks
$90 USD 2 päivässä
5,0 (239 arvostelua)
7,6
7,6
34 freelancerit tarjoavat keskimäärin $138 USD tätä projektia
Käyttäjän avatar
Hi, I am Anna with more than 7 years experience in web and cross-platform app development including Hybrid, PHP, Laravel framework, Slim, CodeIgniter, MySQL, PostgreSQL, HTML, CSS, Javascript, jQuery, Vuejs, Ajax, WordPress template & plugin, WooCommerce. I am able to write the script to import text file into SQL db and use cron job to run daily. I am ready to discuss and start now. If I am chosen for this project, I commit preparing the development site and updating project status daily or whenever you message me. Thank you for your consideration. I am looking forward to your reply. Sincerely, Anna
$150 USD 3 päivässä
5,0 (14 arvostelua)
5,8
5,8
Käyttäjän avatar
INTRODUCTION I can see you are interested in importing file into your back-end database. I have also studied your subdivision txt attachment. I have done so many database administration of this website before and I am confident I can handle your project. SIMILAR PROJECTS COMPLETED: • https://www.freelancer.com/projects/php/import-update-telecom-marketing-database/?w=f • https://www.freelancer.com/projects/sql/human-resources-database-creation/ EDUCATION • BSc Computer Sciences, University of Hertfordshire, UK 2014 • Microsoft Certified Business Intelligence Developer 2009. • Microsoft Certified SQL Server Administrator 2008. • compTIA A+ Certified 2008.
$150 USD 3 päivässä
4,8 (23 arvostelua)
6,0
6,0
Käyttäjän avatar
Hi employer I have a good experience in sql I am a dB expert So I wish you will work with me for this project Please reply me kindly Thanks
$172 USD 1 päivässä
5,0 (11 arvostelua)
5,4
5,4
Käyttäjän avatar
Hello, Hope you are doing well. I can help with you in your project Import complicated Text file into SQL Database. I can assure you the quality job. I have good experience in Database Programming, Microsoft SQL Server, SQL. We have worked on several similar projects before! We have worked on 425+ Projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. Thanks,
$180 USD 3 päivässä
5,0 (10 arvostelua)
5,5
5,5
Käyttäjän avatar
Hello, it seems it's csv file with tab delimited. I can create php script which insert this data to your mysql database. I can deliver you php script in 3-4 hours at most. Then, you can create cronjob for it to run everyday.
$100 USD 1 päivässä
5,0 (21 arvostelua)
4,8
4,8
Käyttäjän avatar
Hi. I'm Enkhbayar B in Japan. I have read your description in detail and have interests in your project. I have many experiences that have ever done what is similar to your project. As a solution, I have a good idea to build your project perfectly without going through a bunch of DTS Import wizard steps. I would like to have a discussion with chat to get more about your project. Thanks.
$150 USD 3 päivässä
4,9 (9 arvostelua)
4,1
4,1
Käyttäjän avatar
hi there I have read your description i it is possible on pyton or c# I cando all as your reqruiement thanks
$155 USD 3 päivässä
5,0 (4 arvostelua)
4,1
4,1
Käyttäjän avatar
Hi, Greeting for the day. I will give you the automated script so you need to do it everyday. Lets discuss in details. I can deliver you this project with the best cost in the mention time or less. Let's Discuss. I am expert in doing in database tasks, as I have experience of 4 years in Angular, MySql development and NoSql databases and ERP level projects, so I know how to handle complex database tasks. I also work on native mobile apps. I would like to do your job at lowest rate as I am new to upwork and wanted to do this job only for good reviews. I will only expecting rating from you. I can do this job very fast. You only pay when work is done or after first proof of concept. I gurantee you the full satisfaction and you will be happy with my work. I will be thankful to you, if you award this job to me. Will looking forward to work with you. As a gift I will give you 20% discount and any html site from themeforest for free of cost. Thanks & Regards Dhruv
$122 USD 2 päivässä
5,0 (6 arvostelua)
3,7
3,7
Käyttäjän avatar
Hello, sir. It's a pleasure to meet you. I read your job description very carefully and looked at your attached doc I understand what you want. I can implement what you want using python Python provides powerful libraries and modules for implementing it. Please let me do your job and then I will do my best. You will get all the expected stuff. Kind regards. Bing.
$200 USD 3 päivässä
5,0 (1 arvostelu)
3,7
3,7
Käyttäjän avatar
Hello I have reviewed the file and I can help you to load this to SQL server. My suggested approach is a powerhsell script that you can run that can load the information to SQL server. I have my own environment so I can easily do the testing and deliver the final script. I have a lot of experience both as a DBA and Sysadmin with good shell/powerhshell scripting. Looking forward to work together Regards!
$250 USD 5 päivässä
5,0 (5 arvostelua)
3,8
3,8
Käyttäjän avatar
Hi! Have done such task before. Recording data from xls to database. Let's discuss your needs in chat
$100 USD 5 päivässä
5,0 (13 arvostelua)
3,8
3,8
Käyttäjän avatar
Hi Colleague! We are SQL experts with 15+ years of experience. We can easily help you create a sp to import this file using a Bulk Insert process, i’ve seen the file and this would be easy to import to MSSQL. We will work on our test environment and send the script which will create the SP and the SQL job for you. You pay once you have the script on your sever deployed and you’re happy with the results. Thanks!
$220 USD 1 päivässä
5,0 (2 arvostelua)
3,8
3,8
Käyttäjän avatar
I am an experienced Web and Software Developer, and I am very interested in your job post. I have an excellent experience in MVC,.Net Core, ASP.NET, C#, Linq, Entity Framework, MySQL, MSSQL, REST API, JSON, HTML5, Angular JS, JQuery, Javascript. I believe communication is the key to every successful project. I studied attached sample text file. I look forward to discussing project requirements with you.
$222 USD 5 päivässä
5,0 (2 arvostelua)
3,8
3,8
Käyttäjän avatar
Hi I can write a script or an application for you to import your text file to database. I prefer application. Lets talk about the details Regards Fatih
$222 USD 3 päivässä
5,0 (4 arvostelua)
3,6
3,6
Käyttäjän avatar
Hi, I can help you with this project. I will write you a small c# script that will connect to the database and import this file format into the table. You were right about the table columns. I can complete this in one day. Thanks
$88 USD 3 päivässä
5,0 (4 arvostelua)
3,3
3,3
Käyttäjän avatar
Hi, I am PHP/MySQL coder and would like to generate the script for you. The file you provided is a simple CSV file. Usually CSV is seperated by comma, but in your case it's space(s). This shouldn't be a problem. I can code a script where you can upload, drag'n'drop or paste the file. The script will than import all needed data to your database. 1 step only :) You can contact me via chat/PM for any questions. Sincerely, Ozzy
$77 USD 3 päivässä
4,8 (1 arvostelu)
3,3
3,3
Käyttäjän avatar
Hi, I have seen the file that you have attached in the requirement and can understand the format mentioned. I am sure that I would be able to complete this project as required as I have worked on similar requirements before as well.
$83 USD 3 päivässä
5,0 (6 arvostelua)
3,2
3,2
Käyttäjän avatar
Hi, Sir. Nice to meet you. I have seen your attached file. I have rich SQL experience. I can do perfectly. We can discuss more detail on Chatting Room. Thank you.
$155 USD 3 päivässä
5,0 (2 arvostelua)
3,1
3,1
Käyttäjän avatar
Hello there I can do a php script to automatic run each day and import data Contac me !!
$83 USD 1 päivässä
5,0 (4 arvostelua)
2,7
2,7
Käyttäjän avatar
This looks fairly straight forward. Assuming you have SA (System administration) privileges on SQL I can do this one of two ways depending on your preference: 1. Create a SQL Server Integration Package, Deploy and schedule it to run on a recurring basis of your choosing 2. Create an ODBC connection to the file, create a linked server on SQL Server and the use TSQL scripting in a stored procedure to do the data import. I would create a similar scheduled task to option 1 that would call the stored procedure. I have over 20 years experience in nothing but database development and business intelligence (reporting, data warehousing, etc). I am a native English speaker from and residing in the United States (Pacific Standard Time). I'm new to this site so I am bidding on projects at about 1/4 of my typical rate in order to establish my profile, so this is a great opportunity to get expert assistance at an offshore rate. I've spend the last 14 years as a technical consultant and still do it as my day job so you can rest assured you will receive a high quality of work product and communication. Let me know if you have any questions regarding my experience. Regards, Matthew
$155 USD 2 päivässä
5,0 (1 arvostelu)
2,4
2,4

Tietoja asiakkaasta

Maan UNITED STATES lippu
Coeur D Alene, United States
4,9
29
Maksutapa vahvistettu
Liittynyt kesäk. 5, 2007

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.