1

Resolved

Use absolute address in ETL file location.

description

Hi Chao,
 
One suggestion for Vulcan 2:
 
The below xml gives me 2 packages, when I open ETLTest1 in Visual Studio and execute, then it will give a warning box instead of opening ETLTest2 package. The reason is the file connection is using a reference address. I’m thinking if you can fix it in Vulcan to use absolution address like this:
 
C:\detego\bin\ETL\ETLTest1....\ETL\ETLTest2\ETLTest2.dtsx
 
Thanks!
Jovi
 

 
 

<?xml version="1.0" encoding="utf-8" ?>
<Vulcan xmlns="http://tempuri.org/vulcan2.xsd">
<Using>Detego.Connections.DataWarehouse</Using>
<Package Name="ETLTest1" Type="ETL">
 
    <ExecutePackage Name="ETLTest2" RelativePath="..\..\ETL\ETLTest2\ETLTest2.dtsx"/>
 
</Package>
 
<Package Name="ETLTest2" Type="ETL">
 
    <ExecuteSQL Name="Test" ConnectionName="DataWarehouse">
        <Body>
            SELECT 1
        </Body>
    </ExecuteSQL>
 
</Package>
</Vulcan>

comments