SQL Agent Environment Variables not usable from Referenced Environment
I am trying to set up a SQL Agent Job in SQL Server 14.0.3436.1 (2017), using the SSIS Catalog as a source for an SSIS Package.
When I add the package, I can choose the environments I have set up, but for some reason I do not get presented with the radio button to "Use Environment Variable" for the package variables, so I can only hard code the values.
Any ideas what is going on here? All my Googling just tells me how to set up environments and variables, or how to access them with Python - I haven't found any references to a known bug or anything like that.
I have attached a video to demonstrate what I mean (although what I am showing is the absence of a button!)
If you want to map an environment variable to a project/package parameter - you can do it from the project configuration menu (SSMS/Integration Services Catalog/SSISDB//Projects and select "configure" from the right click menu)
When creating a SSIS step in SQL Agent Job you can select the environment that should be used for populating package/project parameters or you can overwrite the value with a static text
Here is a detailed description with screenshots: https://www.mssqltips.com/sqlservertip/4810/setup-environment-variables-in-sql-server-integration-services/
- query multiple IIF statement
- count distinct values while left joining
- MySQL: Order by Count(*)?
- How to select data items of a certain length?
- Comparing JSON-typed column with specific string value
- How to treat MAX() of an empty table as 0 instead of NULL
- Declare variable in SQLite and use it
- Is there any better option to apply pagination without applying OFFSET in SQL Server?
- Snowflake: Using multiple AND/OR statements breaks my date filter
- How to get the insert ID in JDBC?
- Add a column to a DB2/400 table with a specific ordinal position
- SQL conditional MAX extraction
- Drop Column from Large Table
- Can using isnull in a where statement cause problems with using indexes?
- How do I correctly use two Not Exists statements in a where clause using Access SQL VBA?
- SQL Concat Subquery
- Oracle client appears to be transmitting all 4000 varchar characters for each row
- Java JDBC executeUpdate not working on Delete SQL with TRUNC function in where clause
- Oracle thinks table doesn't exist during alter
- How to bulk update sequence ID postgreSQL for all tables
- Remote clickhouse error: DB::Exception: There's no column '__table1.event_params.key' in table '__table1'
- How do I catch a query exception in laravel to see if it fails?
- How can I use LEFT & RIGHT Functions in SQL to get last 3 characters?
- SQL Stored Procedures not finishing when called from Python
- Make a paginated table without offset limit
- How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?
- How do composite indexes work?
- Rank rows by specified partition
- SQL Get "ISO Year" for ISO Week
- How to insert an array value to an existing JSON document?