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.