SSIS in SQL Server 2012 now supports a “Project Deployment” model. Adding things like Connection Strings is relatively intuitive.
I want to use a parameter to set my CheckPointFileName property.
How can you do this so it can be configured by the environment.
- Create a parameter in your package and call it “CheckpointFileName”
- Click On the ellipses “…” on the Expressions property.
- In property Choose CheckPointFileName from the drop down
- Set the expression by opening the expression builder and choosing the parameter you just created, (sometimes you need to drag and drop the paramater into the expression box)
- Click OK
Now you can deploy your package and set this parameter as part of you environment setup and change the checkpoint file name as required