February 19, 2017 at 4:33 am
Hi,
I want to change/alter the file path variables, i.e. Incoming,download and archive for a given/selected project or packages.(Looking for a automation/ T-SQL process as I need to change the path for more than 100 packages.)
I have another variable called PresentFilePath. I want to readthe value PresentFilePath first. If it is set to "X/: kk/incoming path"I want to change the File path value from "X/: incoming path" to “N:\incomingPath”
Ex: PresentFilePath ("X/:kk\incoming path") à “N:\kk\incomingPath”
PresentFilePath ("X/:kk\Downloadpath") à "N/:kk\Downloadpath"
Is this true--or is there something I need to do differentlywhen dealing with this project level variables?
When I test the package manually by changing the parametervalues under the integration service catalog/environments--I get the file path Iexpect. This package will run via sql agent job. Is there a pre-ssis step I cancreate and execute to do this simple task outside of SSIS?
Thank you,
February 22, 2017 at 2:33 am
If you use the Project Deployment Model you can set up parameters in your project, either at the project level or package level. (You can even tailor these to your environments Development, Testing and Live for example, so that they have different values for each).
Once the project is deployed you can set up SQL Agent Jobs and override the default parameter values and have different jobs that runs the same package but with different parameter values.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply