Find Jobs
Hire Freelancers

Import complicated Text file into SQL Database

$30-250 USD

Fullført
Lagt ut over 5 år siden

$30-250 USD

Betalt ved levering
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!
Prosjekt-ID: 18502811

Om prosjektet

34 forslag
Eksternt prosjekt
Aktiv 5 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
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 om 2 dager
5,0 (239 omtaler)
7,6
7,6
34 frilansere byr i gjennomsnitt $138 USD for denne jobben
Brukeravatar
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 om 3 dager
5,0 (14 omtaler)
5,8
5,8
Brukeravatar
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 om 3 dager
4,8 (23 omtaler)
6,0
6,0
Brukeravatar
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 om 1 dag
5,0 (11 omtaler)
5,4
5,4
Brukeravatar
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 om 3 dager
5,0 (10 omtaler)
5,5
5,5
Brukeravatar
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 om 1 dag
5,0 (21 omtaler)
4,8
4,8
Brukeravatar
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 om 3 dager
4,9 (9 omtaler)
4,1
4,1
Brukeravatar
hi there I have read your description i it is possible on pyton or c# I cando all as your reqruiement thanks
$155 USD om 3 dager
5,0 (4 omtaler)
4,1
4,1
Brukeravatar
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 om 2 dager
5,0 (6 omtaler)
3,7
3,7
Brukeravatar
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 om 3 dager
5,0 (1 omtale)
3,7
3,7
Brukeravatar
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 om 5 dager
5,0 (5 omtaler)
3,8
3,8
Brukeravatar
Hi! Have done such task before. Recording data from xls to database. Let's discuss your needs in chat
$100 USD om 5 dager
5,0 (13 omtaler)
3,8
3,8
Brukeravatar
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 om 1 dag
5,0 (2 omtaler)
3,8
3,8
Brukeravatar
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 om 5 dager
5,0 (2 omtaler)
3,8
3,8
Brukeravatar
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 om 3 dager
5,0 (4 omtaler)
3,6
3,6
Brukeravatar
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 om 3 dager
5,0 (4 omtaler)
3,3
3,3
Brukeravatar
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 om 3 dager
4,8 (1 omtale)
3,3
3,3
Brukeravatar
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 om 3 dager
5,0 (6 omtaler)
3,2
3,2
Brukeravatar
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 om 3 dager
5,0 (2 omtaler)
3,1
3,1
Brukeravatar
Hello there I can do a php script to automatic run each day and import data Contac me !!
$83 USD om 1 dag
5,0 (4 omtaler)
2,7
2,7
Brukeravatar
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 om 2 dager
5,0 (1 omtale)
2,4
2,4

Om klienten

UNITED STATESs flagg
Coeur D Alene, United States
4,9
29
Betalingsmetode bekreftet
Medlem siden jun. 5, 2007

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.