SSIS Execute Package File Connection Help
Posted on 2014-11-19
Hoping this is simple. I have an SSIS package that I need to deploy to a batch server. I found a sample one that I am using and modified. I have a Master package master.dtsx and in that package I am writing to a log then running multiple other packages then logging completed in the master package. So I have three Execute Package Task Editors that use three connections in the connection manager that are the other packages. The sample I have has a variable in the master package called "BasePath" that I have been filling out with my C: drive path to the solution. All these packages are under the same folder. In the master package code it shows for example:
<DTS:Property DTS:Name="CreationName">FILE</DTS:Property><DTS:PropertyExpression DTS:Name="ConnectionString">@[BasePath] + "CDCCashflow.dtsx"</DTS:PropertyExpression>
Stupid question is can I just have it look in the same root path for the files instead of having to enter in a base path to get it to run? This way I don't have to enter in a hard path.