Faster Extraction & Loading by SSIS
Lots of things really matter when building an efficient and robust database and its corresponding package for extracting and loading of data. And this matter more when the database size is very big (or huge).
It’s high time when we need some method to optimize the extraction and loading process in the package. This means increasing the performance of SSIS package and which in turn makes your package to be able to retrieve and update the data they want very quickly.
The key component for faster extraction is to put indexes in the target table but it will give you less performance when you load data on it. So when to put indexes and where to put indexes is very important. Insert indexes to the joining columns before starting extraction, especially to those that have data types other than integer like varchar, nvarchar, datetime, etc.
Secondly, the data type chosen for a particular column also plays a significant role in the performance of your SSIS package. Choose data type and size of the columns wisely.
Recent Comments