varigence / BimlPit

Public Issue Tracker for all Varigence Biml products
6 stars 0 forks source link

Import of backup package doesn't work #25

Open bweissman opened 7 years ago

bweissman commented 7 years ago

see eMail with package

bweissman commented 6 years ago

not quite fixed yet - attached package gives an empty variable Input:

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <Packages>
    <Package Name="OLAPBackup" Language="None" ConstraintMode="LinearOnCompletion" ProtectionLevel="EncryptSensitiveWithUserKey">
      <Tasks>
        <AnalysisServicesExecuteDdl Name="OLAP Backup" DelayValidation="true" ConnectionName="OLAP">
          <VariableInput VariableName="" />
        </AnalysisServicesExecuteDdl>
      </Tasks>
      <PackageConfigurations>
        <PackageConfiguration Name="VAR_OLAPBackupSkript">
          <ExternalFileInput ExternalFilePath="VAR_OLAPBackupSkript" />
        </PackageConfiguration>
        <PackageConfiguration Name="VAR_ServerName">
          <ExternalFileInput ExternalFilePath="VAR_ServerName" />
        </PackageConfiguration>
      </PackageConfigurations>
    </Package>
  </Packages>
</Biml>
bweissman commented 6 years ago

OLAPBackup.zip

varigence commented 6 years ago

This does not appear to be a valid package, which is the source of the issue. The olap backup task and the package configuration both reference a variable that is never defined. If you go into the package configuration screen and try to edit the variable configuration, for instance, you will get an error. Does this package work for you?

bweissman commented 6 years ago

it does - attaching full project here. We can discuss in our call.

Backup Automation.zip

varigence commented 6 years ago

This is caused because the child package is being called by a parent package. The variable referenced in the child package is defined in the parent package. This will never work when imported as individual packages, but we will fix it for the project import scenario.