Closed

MS Navision SQL query to import data from flatfile in DB

We need a query that automaticly (e.g. every day at 4pm) imports data from a [url removed, login to view] in our db (ms sql) with:

> fieldterminator ";" and

> rowterminator "\n"

If the row exists in table then not overwrite

If its an new flatfile then make an empty row

> After import is done, rename [url removed, login to view] in [url removed, login to view] or move the file into a subfolder

Thats in short. Is this possible?

Skills: Dynamics, SQL

See more: navision sql, row 44, sql query, sql microsoft, query table, navision, ms dynamics, move sql, microsoft dynamics navision, dynamics navision, db query, 2013 query, navision 2013, sql move data, short microsoft, microsoft navision dynamics, sql txt, need sql query, import txt sql, sql data txt import, sql day, read data sql project, sql import, import txt, import data sql table

About the Employer:
( 2 reviews ) Münster, Germany

Project ID: #4497136

24 freelancers are bidding on average €67 for this job

MMaghawry

I can do a windows service to run in the background and watchs the folder , so it can import the data from the new flat file into the DB, then move it to another folder or subfolder it will be configurable.

€77 EUR in 3 days
(15 Reviews)
4.6
DeoTech

Hi! I can do this task. MS SQL can import txt fields. Also C# small file can do this work. Regards.

€66 EUR in 3 days
(4 Reviews)
3.5
Reza2012

Hi I have more than nine years experience in Database administration and data migration. Please see my profile. Thanks.

€88 EUR in 7 days
(2 Reviews)
3.3
sveralex

Hello, can you post a piece of flatfile.txt file and MS SQL database structure? Only one table should be updated ?

€84 EUR in 3 days
(1 Review)
3.1
swagatab

Hello, Do you want to run this on a Windows based server? I can do this in Classic ASP and schedule the script as a standard windows scheduled task. Some more details on the flatfile will be helpful. Regards, Sw More

€83 EUR in 3 days
(2 Reviews)
2.9
pablotorres

i can do it

€34 EUR in 7 days
(5 Reviews)
2.7
vhrios

i can do it easily!Thanks in advance!

€61 EUR in 2 days
(1 Review)
2.6
staretzu

Hello, I can do this with SSIS. I will create a package that does all that you asked and will schedule using SQL JAM to run when desired. Thanks, Mihai

€34 EUR in 3 days
(1 Review)
1.6
SurfrazAhmad

We can Write a Job Which Will do this

€88 EUR in 3 days
(1 Review)
1.5
luki555

Hi. Check your PM please.

€66 EUR in 3 days
(1 Review)
1.1
aoefmpes

pl check your inbox

€61 EUR in 3 days
(1 Review)
0.0
sachit27

It could be done through windows based exe that could be scheduled through a windows scheduler every day 4 PM. I can do it if required.

€61 EUR in 3 days
(0 Reviews)
0.0
navsupport

Hi, Please check your PM.

€61 EUR in 3 days
(0 Reviews)
0.0
Rajmohan007

Hi, Please check my Personal message. Regards, Raj

€72 EUR in 3 days
(0 Reviews)
0.0
Renjithmac

I can do it .

€50 EUR in 3 days
(0 Reviews)
1.0
aternex

I can develop this for you in a multitude of ways. If you would like a windows service to monitor the directory that can be done or if you prefer using SSIS or a console app that gets scheduled then that is doable as w More

€83 EUR in 4 days
(0 Reviews)
0.0
pixlbrick

hello, Lets go on....! :)

€103 EUR in 4 days
(0 Reviews)
0.0
Dennis23408

Hi, I can write a sql script to do it, and running automaticly as sql job.

€50 EUR in 3 days
(0 Reviews)
0.0
singharun7

i have a good exp in this field so i can handle it easily..................

€66 EUR in 5 days
(0 Reviews)
0.0
D3v3loper

please check my pm

€73 EUR in 3 days
(0 Reviews)
0.0