SSIS is one of the best ETLs
July 16, 2018
SSIS is one of the best ETLs
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with SQL Server Integration Services
SQL Server Integration Services is used for the following purposes in my organization.
1. Extract data from the source database and transform it and then load it into a destination database
2. Use this for Balancing between 2 or more different databases
3. Extract the data from relational databases and load into data ware house.
1. Extract data from the source database and transform it and then load it into a destination database
2. Use this for Balancing between 2 or more different databases
3. Extract the data from relational databases and load into data ware house.
- Transform the data
- Lookups
- Performance
- Script components are always a problem
- Cannot debug properly inside of Script component
- Positive Impact: Faster Performance
- Negative Impact: Script Task and Script component always hangs up