ssis - Importing flat file and Creating reports sql server -

i have ragged right flat file has 168 columns. type of flat file daily , need create various reports , send these reports various departments of company. task load flat file sql server database reporting purposes. 168 columns should go 22 different tables , when storing in different ttables, should in correct datatypes can suggest process this.

i need covert column before loading each table.

and table, create reports.

thank time !

i worked similar type of project , here scenario , did if helps you.

scenario files dumped via ftp @ midnight, file should processed , generate report everyday [early first hour].

solution fixed folder dump file everyday , designed ssis import large table [168 columns table on our case] i.e.table importstaging, had column dateimported , filename keep track file , date imported. , had procedure populated other tables. , ssrs report on place.

now designed sql job,

step 1: import using ssis package

step 2: ssis package move imported files filedumpyard drive

step 3: exec proc --[populated proper tables , generate summaries]

and scheduled job morning. that's it

my reports ready before off bed :)