March 13, 2014 at 2:07 pm
On Microsoft's site they state this for behavial changes of SSIS in 2008R2.
Dtexec option and usage:
Using the /Set option to change the location from which the utility loads design-time configurations
Behavior in SQL Server Integration Services 2005:
Has no effect.
After the utility applies the run-time options, the utility does not reload the design-time configurations.
Behavior in SQL Server Integration Services 2008:
Succeeds.
After the utility applies the run-time options, the utility reloads the design-time configurations from the new location.
http://technet.microsoft.com/en-us/library/bb500430(v=sql.105).aspx
However I can not find anything on any forum that can clearly show how this can be done. I have tried multiple property paths that would make sense but still nothing.
Does anyone know what the syntax is to make this re-direction?
March 13, 2014 at 8:24 pm
have you reviewed this information?
http://technet.microsoft.com/en-us/library/ms162810(v=sql.105).aspx
March 14, 2014 at 5:59 am
Yes I have reviewed that over and over. Asking for help is typically my last course of action. I know how to use the /SET option and the others I just don't know what the path (for inside the package) for redirecting the design-time configuration location that should be used with the /SET option or if there is some other form of syntax to be used.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply