Lukket

BCP MSSQL convert empty columns to \N

Job Description:

Hi,

I am looking for some help on the following project.

BCP is used to create exports of MSSQL tables. Example:

2133|test||1|0|

The desired export format is:

2133|test|\N|1|0|\N

Meaning, the empty slots should be replaced by \N. The tables are very large so we it needs to be a fast working solution.

Færdigheder: SQL, Microsoft SQL Server, MySQL, Linux

Om klienten:
( 51 bedømmelser ) 's-Gravenzande, Netherlands

Projekt ID: #36215877

27 freelancere byder i gennemsnit €134 timen for dette job

youssefEngineer

hello sir, i'm python expert, and i used to create tools that do some specific tasks like yours, in order to change the empty slot into the \N i can work on this and test it together before the delivery so that we can Flere

€200 EUR på 1 dag
(3 bedømmelser)
6.4
Nirmal5828

Hi, I have 7+years of experience with MSSQL query designing and migration through MSEXCLE and other heterogeneous sources, would like to work on this project, will try to give my best.

€240 EUR in 7 dage
(1 bedømmelse)
6.1
logicalsoft

Work on this field more than 20 years and have high experience so can introduce great work and fast deliver so need to talk for more details about the project

€140 EUR in 7 dage
(55 bedømmelser)
6.0
michealperfect

Hello Roy V., We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on Linux, SQL, MySQL, Microsoft SQL Server Plea Flere

€170 EUR in 7 dage
(34 bedømmelser)
5.9
drsixpence

You probably need a custom script which allows you control things like that column separator that connects to the DB then generates the CSV files for you automatically and I'm ready to make just that for you within jus Flere

€120 EUR på 1 dag
(38 bedømmelser)
5.6
kundansql

Hi there! Let me help you out... I would like to help you to make the required changes. I know 500-level things about Microsoft SQL Server. I have 7+ years of exceptional knowledge and experience in both SQL Server P Flere

€40 EUR på 1 dag
(34 bedømmelser)
5.0
awais26

Hi, I have a background in database administration in MS SQL server and have been doing this for 7+ years. I have experience and can work with you to export tables to text file and replace empty columns with \N. In thi Flere

€100 EUR in 7 dage
(17 bedømmelser)
5.2
goodwork20k

Hello, I am good in Powershell and database and help you to create powershell script to replace the empty slots into \N Please ping me for further discussion Thanks

€140 EUR på 1 dag
(20 bedømmelser)
5.1
vinod150987

Hi, Hope you well ! I have 12 + years experience in .NET with C#, VB, ASP.NET MVC, ASP.NET Core, IIS, Web Service, WCF, JavaScript, jQuery, SQL, SSIS, SSRS, XML ,XSLT and HTML. I have long experience with right skills Flere

€150 EUR in 7 dage
(9 bedømmelser)
4.1
Topgmaster

Hi, In order to accomplish this task, we can discuss several approaches and determine the best course of action based on your specific requirements. I will work closely with you to understand the scope of the project, Flere

€300 EUR på 1 dag
(1 bedømmelse)
3.4
ashrafsbai6655

Hey , i have read you posting and i am happy to tell you that i have a python script to that fast and already ready!!! Looking forward to hearing from you

€30 EUR på 1 dag
(3 bedømmelser)
2.1
muneebsuri1

Hi, I can definitely help you with your project to modify the export format of your MSSQL tables. I understand that you need empty slots to be replaced by "\N" in a fast working solution. I have experience working wit Flere

€80 EUR in 2 dage
(0 bedømmelser)
0.0
deepakpandit2412

Hello, Greetings for the day...! I am intrested in this work. I have 4 yrs of exp in .Net application development. This task is very easy for me I will privide you the solution also will check fast working solution. Flere

€140 EUR in 7 dage
(0 bedømmelser)
0.0
krlosgzman

Tengo la solución .. solo déjame revisar el tema y negociamos .. se puede realizar un reemplazar de columnas en sql o se puede hacer con una transformación de datos

€140 EUR in 7 dage
(0 bedømmelser)
0.0
bhagyasreedekond

Hi, I am a proficient in MSSQL and SQL with 5 years of working experience in a real time project. Also experienced with such exports where my client wanted certain reports to be pulled on a regular basis with new requ Flere

€230 EUR in 10 dage
(0 bedømmelser)
0.0
softtrain

Hi Greetings! I am available right now for the project discussion and can start the project on an immediate basis. I have understood your project requirement I have7++ experience in design and development. I can ha Flere

€250 EUR in 7 dage
(1 bedømmelse)
0.0
vaishalign76

Hey, I already worked on mysql or Sql Server, I have good knowledge about sql server. I can Easily Make queries according to your requirement. Please accept my bid. Thanks in advance

€40 EUR in 3 dage
(0 bedømmelser)
0.0
sunilyelapure4

HI, I have seven years of experience in MS SQL, I know the MS SQL in and out. I have resolved the many SQL issues similar to this over the period so confident about resolving of this issue as well.

€140 EUR in 4 dage
(0 bedømmelser)
0.0
shadabsk54

I am working as a database developer so I can work on this project. I will complete this project as soon as possible due to weekend availability.

€140 EUR in 7 dage
(0 bedømmelser)
0.0
saurabhtkd

Hi, Can I review this task. I am available to support you Please go through my profile. I have 6+ year of experience Regards,

€140 EUR in 7 dage
(0 bedømmelser)
0.0