<div>
I haven't used SSIS over ECS, so not sure whether my default suggestion with respect to Environment variables might help you or not..<br />
<br />
&gt;&gt;&nbsp;In Microsoft Azure Enterprise Cloud Services (ECS), I have a variable ENVIRONMENT=DEV\DEV<br />
<br />
By Default, SSIS Environment variables is different than Windows environment variables and can't access as such..<br />
Please find more info about SSIS Environment variables and how to use it below..<br />
<a href="https://www.sqlchick.com/entries/2015/1/4/parameterizing-connections-and-values-at-runtime-using-ssis-environment-variables" rel="ugc">https://www.sqlchick.com/entries/2015/1/4/parameterizing-connections-and-values-at-runtime-using-ssis-environment-variables</a>
</div>


I haven't used SSIS over ECS, so not sure whether my default suggestion with respect to Environment variables might help you or not..

>> In Microsoft Azure Enterprise Cloud Services (ECS), I have a variable ENVIRONMENT=DEV\DEV

By Default, SSIS Environment variables is different than Windows environment variables and can't access as such..
Please find more info about SSIS Environment variables and how to use it below..
https://www.sqlchick.com/entries/2015/1/4/parameterizing-connections-and-values-at-runtime-using-ssis-environment-variables [https://www.sqlchick.com/entries/2015/1/4/parameterizing-connections-and-values-at-runtime-using-ssis-environment-variables]

HelpDesk Technician

Michael Elliott

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm using Visual Studio 2017.<br />
<br />
QUESTION: <br />
In Microsoft Azure Enterprise Cloud Services (ECS), I have a variable ENVIRONMENT=DEV\DEV<br />
<br />
In SSIS 2017, how do assign a variable varEnvironment equal to the ECS variable ENVIRONMENT=DEV\DEV ?
</div>
</div>


Hi,

I'm using Visual Studio 2017.

QUESTION: 
In Microsoft Azure Enterprise Cloud Services (ECS), I have a variable ENVIRONMENT=DEV\DEV

In SSIS 2017, how do assign a variable varEnvironment equal to the ECS variable ENVIRONMENT=DEV\DEV ?

In SSIS 2017, how do assign a variable varEnvironment equal to the ECS variable ENVIRONMENT ?

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.

SSIS

Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft. It is used to develop computer programs for Microsoft Windows, as well as web sites, web applications and web services. Visual Studio uses Microsoft software development platforms such as Windows API, Windows Forms, Windows Presentation Foundation, Windows Store and Microsoft Silverlight. It can produce both native code and managed code.