Avatar of Ali Saad
Ali Saad
Flag for Kuwait asked on

Import data from flat files to sql server

What the best solution for the following scenario

I have a table 
Create table  trns (
Sp_name nvarchar (150),
Amount decimal (12,3),
Acc_no nvarchar(14),
Bank_Id tinyint ,
Trn_Date date 
)

Every month i have to import a data from different 3 data sources 
( .txt , .mdb , .xls ) and load it in this table.... Note i dont delete the old data from this table but i ADD the new data to it
All data source has a different column names , different column numbers .... But all have a columns i need to import it in the above columns
So what the best option i have to use to perform this task  and to AUTOMATE it .... Is using SSIS and  save it and give it to the end user to use it every month to imort the data ? ..........or using tsql like bulk insert and make small a .net application to let the user use it ......
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Ramesh Babu Vavilla

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Banthor

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Ramesh Babu Vavilla

i suggest you to create SSIS packacge adn schedulit
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck