Performance tuning at Source level in SSIS

·         Source as Flat File, use the property “Fast parse=True”. So that the column uses faster

 (see this article)

·         Source as Database (Table or View), Create indexes on the source table so that it retrieves the data faster. Instead of taking a table, take an SQL Query (or) SQL Command as data access mode to get the required columns and rows of data.