Mapping columns of Flat File to DB table columns.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

How can we use SSIS for transfering data between flat file source to
SqlServer DB existing table.
Consider a scenario of an flat file where there is one column "Company
name" but in the targeted Destination DB table there is "Company ID"
column which is a foreign key column, how do we handle this situation
while working with SSIS.

Thanks!

Regards,
TechFreak.

.

Relevant Pages