SSISUtilityDemo

preview_player
Показать описание
This SSIS Utility is very helpful in every day-to-day SSIS
Tasks.
The Features of this utility.
1. It compares two ssis packages.
Working on a version of SSIS package we can use this tool to compare our new and old version of SSIS Package.It will tell us the change in variables between those SSIS Packages.

2. It helps us to search for a value within variables of SSIS Package.
We may be using SQL queries as Variable expression.With this feature we can search all those variables using a particular table/column/database value. It helps us in our maintainence activities where we have to make change to a query but not sure that which all variables are using that query.

3. It helps us to track the variables.
We may want to delete or modify a variable but dont know where all that variable is getting used. The variable may be used as :
Expression of other variable
Resultset of Task
Parameter of Task
Statement of Task
This feature helps us to track the usage of that variable so that we may safely modify or delete a variable by changing all the places where that variable was getting used

This tool is uploaded on codeplex and a demo is uploaded on youtube.
This tool is my small contribution to entire SSIS community and I request all to make this tool more effective.

Рекомендации по теме
welcome to shbcf.ru