View Original Post Here:[^]:Create your variables in the Variable tab, mine are ProjectServer (String), DBName (String)
Create your DB Connection Object connecting directly to the actual Server and Database...Test your Connection
Right Click on the Connection Object and Select Properties
In the Properties Window Select Expressions by clicking the grey box with 3 dots ...
Select ConnectionString from the dropdown in the 1st column, then click the grey box with 3 dots.
In the Expression Editor that opens enter the following: "Data Source=" + @[User::ProjectServer] + ";Initial Catalog=FinancialProcessing;Integrated Security=True;"
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)