0

Hi is there a way to edit the package.params file in a SSIS solution without visual studio?

Keag1
  • 141
  • 1
  • 11

2 Answers2

0

I have a feeling that what you're wanting to do is set a new value for the package parameters at runtime. You can set these in the package store or in the execution settings, http://www.sqlchick.com/entries/2015/1/4/parameterizing-connections-and-values-at-runtime-using-ssis-environment-variables .

Bruce Dunwiddie
  • 2,888
  • 1
  • 15
  • 20
0

I found out that there are no external applications needed you can do it through environment variables and SSMS You can read the full article here

How to configure SSIS 2012 project to run under different environment configurations?

Community
  • 1
  • 1
Keag1
  • 141
  • 1
  • 11