[Dynamic Package] Directory Check

Hi,

IN context to what calculated value means 

I have a simple script , it checks if c:\tmp exist , if not create it , it works as a package script , but gives error when I run this directory check calculated value 

import os
import etltools

try:
    folder_path = r'C:\tmp'
    if not os.path.exists(folder_path):
        os.makedirs(folder_path)
    Result.Value = 1
except Exception as e:
    etltools.SetVariable('error_message', str(e))
    Result.Value = 0

 

In case of directory check you script must return as string value which represent a "Directory path" you want to check 

OK, makes sense, 

Below worked

import os
import etltools

try:
    folder_path = r'C:\tmp'
    if not os.path.exists(folder_path):
        os.makedirs(folder_path)
    # Return folder path if successful
    Result.Value = folder_path
except Exception as e:
    # Return error message if an exception occurs
    etltools.SetVariable('error_message', str(e))
    Result.Value = "Error"
 

admin wrote:

In case of directory check you script must return as string value which represent a "Directory path" you want to check 

Can this be assumed for all calculated values? A string must be returned ?

1 Your script is wrong,
There is no need to check if directory exists inside the script.
AETL does it for you.

The execution sequence is:

1. All parameters are calculated/assigned
2. Action is executed
3. Depending on execution result next action is executed.

Calculated parameters give a lot a lot of flexibility but they must be used with caution   

2 Can this be assumed for all calculated values? A string must be returned.
  
This is correct and depending on the parameter type they must be properly formatted