The concept of SSIS Configurations is no longer applicable with the project deployment mode as they've been replaced with SSIS Environment Variables. This technique is applicable to SQL Server 2012 and up, and only to the project deployment mode (i.e., not package deployment mode). They're also different from "regular" variables inside an SSIS package. Note that these SSIS environment variables are a different thing than Windows environment variables, although similarly named. This functionality is useful for any number of things, frequently for specifying different values between Dev, QA, and Prod environments. SSIS Environment Variables provide the mechanism to set values at the time a package is executed. Screen shots shown are from SQL Server 2014. Although it may seem like a lot of steps, it's a one-time setup per environment and makes your SSIS projects very portable and allows for easier manageability of dynamic values that change routinely.Īpplicable to: SQL Server 2012 or 2014. This post discusses how to parameterize connection strings and values at runtime using SSIS environment variables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |