Inserting data from a text file to sql table

vensali
vensali used Ask the Experts™
on
I have text file which gets created periodically from another program which needs to be inserted/updated to sql table.

What is the best method to it.

SSIS, Bulk insert etc.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vikas GargAssociate Principal Engineer
Top Expert 2014

Commented:
HI,

if the file format is not going to change than SSIS is somewhat better and more systematic way of performing this one.

You can schedule the task with job and hence see the log for maintenance is well.
here are the complete steps  to set up a job for this task :)

SSIS: Importing data from a text file using a package
https://decipherinfosys.wordpress.com/2008/07/28/ssis-importing-data-from-a-text-file-using-a-package/

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial