Link to home
Start Free TrialLog in
Avatar of vensali
vensaliFlag for India

asked on

Inserting data from a text file to sql table

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.
Avatar of Vikas Garg
Vikas Garg
Flag of India image

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.
ASKER CERTIFIED SOLUTION
Avatar of plusone3055
plusone3055
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial