Using Data Profiling Task in SSIS
| Data Profiling is important in data quality processing and transformation. It provides a way to investigate large datasets and to identify incorrectly formatted data. This post explains doing data analysis using Data Profiling task. |  |
Data Profiling task helps you to
- Identify the problems with your data. Example: Finding the products in your data which are not following the naming pattern.
- Identify the missing functional dependencies between columns. Example: State and Zip code columns. It helps you identify wrong ZIP code that has been entered for a state or city.
Setting up Data Profile Task
Related Posts:
2 commentsRuntime Settings with SSIS Package
Introduction
Clients may require to integrate the SSIS packages in their environment(Production). SSIS package settings needs to be changed at run time and all settings needs to be pulled from the database using set of stored procedures.
1. Create a SSIS package and drag the Execute SQL task to control flow in the package as follows
Related Posts:
1 comment
