To overcome these type of scenarios Microsoft has introduced Package parts in SSDT 2015 to overcome this type of circumstances, package parts let us produce package templates that are simpler to use and support. Using package parts we can create reusable and maintainable SSIS solutions.īefore SQL Server 2016 we were able to do code reuse using SSIS templates, but suppose we wanted to refactor or tweak our template, it would prove to be quite tedious for SSIS developer to make changes in all existing packages which are using that template (if the developer is not well versed with BIML). SQL Server 2016 introduced many new features and components in SSIS, one of those features is the Control flow package part which was introduced in SSIS with the release of SSDT 2015.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |