SQL Server Performance

SQL Server SSIS packages metadata solution pack

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Apr 14, 2008.

  1. Anonymous New Member

    Do you have hundreds of SSIS packages to manage? Do they run at various times to address the ETL solutions within your environment? Let's say you have to modify the base table columns, so you need to consider what kind of impact this change would have affect on the various SSIS packages that are dependant within this base table. Have you ever seen the MetaData solution pack, that is one of the discovery tools you can use to explore the impact of a change like this. Even I wasn't aware of this package...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2008/04/14/sql-server-ssis-packages-metadata-solution-pack.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3913" width="1" height="1">

Share This Page