SSIS tutorial
SQL Server Integration Services tutorial & tips
"SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing". SQL Server Integration Services is a high performance Extract-Transform-Load (ETL) platform that scales to the most extreme environments.
This section will contain some useful tips and tricks while using SSIS. This includes some of the real time problems or errors and way to troubleshoot them. If you are looking for step by step detailed tutorial, please refer here
|
|
When you insert data into your target SQL Server database, use minimally logged operations if possible. When data is inserted into the database in fully logged mode, the log will grow quickly because each row entering the table also goes into the log.
|
|
|
One of the main tenets of scalable computing is to partition problems into smaller, more manageable chunks. This allows you to more easily handle the size of the problem and make use of running parallel processes in order to solve the problem faster.
|
|
There are some things that Integration Services does well – and other tasks where using another tool is more efficient. Your tool choice should be based on what is most efficient and on a true understanding of the problem. To help with that choice, consider the following points:
|
This is something very obvious, but many will fail to implement it. It is such an important point that it needs to be made separately. Follow the below guidelines:
- Make data types as narrow as possible so you will allocate less memory for your transformation.
- Do not perform excessive casting of data types – it will only degrade performance. Match your data types to the source or destination and explicitly specify the necessary data type casting.
- Watch precision issues when using the money, float, and decimal types. Also, be aware the money is faster than decimal, and money has fewer precision considerations than float.
|
|
|
|
|
SSIS Tutorial