Read from text file & store in DB...Best way to implement
-
Hi... I have to read one Text file & i have to store content of text file into Database. Which is the best way to implement this task. Because text file will update each & every midnight. I can create one windows service which will run at specify time and store content in the DB.... Is there any other way to implement this task except windows service??
-
Hi... I have to read one Text file & i have to store content of text file into Database. Which is the best way to implement this task. Because text file will update each & every midnight. I can create one windows service which will run at specify time and store content in the DB.... Is there any other way to implement this task except windows service??
Hemant_ec48 wrote:
Is there any other way to implement this task except windows service??
Another way would be to write a console application(for eg) and schedule it run at specific time. But, IMO windows service is a nice approach to follow.
Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
-
Hi... I have to read one Text file & i have to store content of text file into Database. Which is the best way to implement this task. Because text file will update each & every midnight. I can create one windows service which will run at specify time and store content in the DB.... Is there any other way to implement this task except windows service??
Hemant_ec48 wrote:
I can create one windows service which will run at specify time and store content in the DB....
So, this is nothing related with ASP.NET :)
Hemant_ec48 wrote:
Is there any other way to implement this task except windows service??
Yes. Create a normal
Console Applicationfor that, Schedule it usingWindows Scheduler. :-DAbhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.
-
Hemant_ec48 wrote:
Is there any other way to implement this task except windows service??
Another way would be to write a console application(for eg) and schedule it run at specific time. But, IMO windows service is a nice approach to follow.
Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
Aha... I didn't see your response :doh:
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.
-
Aha... I didn't see your response :doh:
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.
Sorry My friend for let reply but i was busy in meeting.... Should i use SSIS from this task... If I create one DTSX Package And if i use that Package from SQL Job I do not have Proper Idea Regarding this ..... But I am getting one advice to implemet this one.... If you have any idea regarding this than Please help me....
-
Sorry My friend for let reply but i was busy in meeting.... Should i use SSIS from this task... If I create one DTSX Package And if i use that Package from SQL Job I do not have Proper Idea Regarding this ..... But I am getting one advice to implemet this one.... If you have any idea regarding this than Please help me....
Hemant_ec48 wrote:
Should i use SSIS from this task... If I create one DTSX Package And if i use that Package from SQL Job
This is also an Good idea. you can . What is ur text file content ? is it like CSV file or what ?
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.
-
Hemant_ec48 wrote:
Should i use SSIS from this task... If I create one DTSX Package And if i use that Package from SQL Job
This is also an Good idea. you can . What is ur text file content ? is it like CSV file or what ?
Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.
Ya Abhi... Text format is like Hemant|Patel|03ec48 ABHI|JANA|03ec49 Like that .... I request you to Please if you have any document regarding this plaese send me link.. Regards, Hemant Patel.