Could not resolve reference to '' in property 'Database'. '' is invalid. Provide valid scoped name

Question

I am working on a data migration project, from Visualfoxpro to Oracle...!

I have successfully created the meta data and the packages script in BIML but when i tried to generate the SSIS package in Visual Studio, it give an error "Could not resolve reference to '' in property 'Database'. '' is invalid.". I am not sure what Database name should be used for and Oracle DB as it's schema driven(In my understanding).

I have followed the article http://bimlscript.com/Walkthrough/Details/73 Changed 1-2-Environment.biml in the following way

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <Connections>
    <OleDbConnection Name="Source" ConnectionString="Provider=vfpoledb.1;Data Source=<Path to VFP database folder>;Exclusive=false;Nulls=false;" />
    <OleDbConnection Name="Target" ConnectionString="Data Source=ServerName;User ID=UserName;Password=Password;Provider=OraOLEDB.Oracle.1;Persist Security Info=True;" />
  </Connections>
  <Databases>
    <Database Name="NameForTheDatabase" ConnectionName="Target" />
  </Databases>
  <Schemas>
    <Schema Name="OracleSchemaName" DatabaseName="" />
  </Schemas>
</Biml>

Since i am new to this technical stack, I am struggling to get a solution for this issue. Any input will be very helpful.

Answer 1

I'd think you just need the same DatabaseName in Databases and Schemas.

  <Databases>
    <Database Name="NameForTheDatabase" ConnectionName="Target" />
  </Databases>
  <Schemas>
    <Schema Name="OracleSchemaName" DatabaseName="NameForTheDatabase" />
  </Schemas>