Inserting data from a text file to sql table

vensali used Ask the Experts™
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.
Watch Question

Do more with

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


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

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