Link to home
Start Free TrialLog in
Avatar of Ali Saad
Ali SaadFlag 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 ......
ASKER CERTIFIED SOLUTION
Avatar of Banthor
Banthor
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
i suggest you to create SSIS packacge adn schedulit