To achieve this objective what we need is
Foreach Loop Container: To Iterate over a directory to pick files.
Data Flow Task: To load data from the CSV (Flat File Source) to the
database table (OLE DB Destination).
Flat File Source: For text or csv files.
OLE DB Destination: To select the dest...
