Copy each recently changed file into the destination database.Within the ForEach activity, read the properties of eachįile, using another Get Metadata activity and pass it to conditionalĪctivity, to determine if the file has been modified within the last 7 days.Get Metadata activity and pass this data to ForEach Read the list of the files available in the source folder, using.To demonstrate Get Metadata activity at work, I will create Iterative activities, to perform copy or transformation activities on a dynamic The data obtained by Get Metadata activity can be used by subsequent As to theįile systems, it can read from most of the on-premises and cloud storages on Azure, The Metadata activity can read from Microsoft's on-premisesĪnd cloud database systems, like Microsoft SQL Server, Azure SQL database, etc. Please note that the childItems attribute from this list isĪpplicable to folders only and is designed to provide list of files and folders Is specified in the GetaMetadata field list, the activity will not failĮven when the item (file/folder/table) does not exist instead, it returns Whether a file/folder/table exists or not. The number of columns inside the file or relational table. Value is a list of column name and column type. Applicable to file only.ĭata structure inside the file or relational database table. The output value is a list of name and type of each List of sub-folders and files inside the given folder. Last modified date/time of the file or folder. The full list of attributes, borrowed from Microsoft's site: Attribute name Some attributes are available only for file-based sources, others available forĭatabase tables and there are few attributes applicable for both types. The list of attributes returned by this activity is dependent on its source type, The Get Metadata activity allows reading metadata information
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |