This XML configuration type can also be used in a DTAP street. The xml/dtsConfig file already exists with the correct values otherwise the package won't work. I have a Connection Manager and I have an XML configuration file to configure its connectionstring. In BIML script you will find this in the variable tag and not in the configurations tag! This is done with Parent Package Variable Configuration. I have a variable that is filled by a variable from the The combination of these two configuration types is often used in a DTAP street. This configuration table is stored in the Meta database. Note: the configurations should already exist in that table ![]() I have a second Connection Manager named Source and I added package configuration to get its value from a SQL Server configuration table. The screens are what the BIML script below will produce. That variable already exists and contains a connectionstring. ![]() ![]() I have one Connection Manager named Meta and I added package configuration to get its connectionstring from a Windows Environment Variable. Screens are from SSIS 2012 package deployment, but it works the same in SSIS 2008. Here are a couple of examples of the most used package configurations. I want to use SSIS Package configurations in my BIML script.
0 Comments
Leave a Reply. |