Avatar of vensali
vensali
Flag 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.
Microsoft SQL Server 2008SSIS

Avatar of undefined
Last Comment
plusone3055

8/22/2022 - Mon
Vikas Garg

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
plusone3055

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23