How to use Expression on Enum Property (e.g. Action property of SSIS Advanced File System Task or Amazon Storage Task)

Question:

I would like to use expression for Action property of Advanced FIle System Task or Amazon Storage Task... How can I do this?

Answer:

To use expression on any property which is Enum (Drop down selection) you have to find associated Numeric value.

For example: Action Property of Advanced File System Task is Enum Property so we need to know numeric value associated with Action. You can Find exact value from Help file.

Here is example on how to find Enum value.

Numeric code for Action Property in Advanced File System Task

[Description("Delete file(s)")]
 DeleteFile = 30,

[Description("Delete folder")]
 DeleteFolder = 40,

[Description("Delete folder (including Subfolders)")]
 DeleteFolderWithSubfolders = 41,


 [Description("Copy file(s)")]
 CopyFile = 50,

[Description("Move file(s)")]
 MoveFile = 60,

[Description("Rename file(s)")]
 RenameFile = 70,

[Description("Search and replace string in file")]
 SearchReplaceFile = 80,

[Description("Change Encoding of file(s)")]
 ChangeEncoding = 81,

[Description("Create new file")]
 CreateNewFile = 90,

[Description("Append data to file")]
 AppendToFile = 91,


 [Description("Create new folder")]
 CreateFolder = 100,

[Description("Create new folder if does not exist")]
 CreateFolderIfNotExists = 111,


 ////------------//
 [Description("Get file(s) size")]
 GetFileSize = 1010,


 [Description("Get file exist status")]
 GetFileExistsFlag = 1030,

[Description("Get files count")]
 GetFileCount = 1040,

[Description("Get file LastModifiedDate")]
 GetFileLastModifiedDate = 1050,

[Description("Get file text")]
 GetFileDataAsString = 1080,

[Description("Get folder exist status")]
 GetFolderExistsFlag = 1090,

[Description("Get lock status of file")]
 GetFileLockFlag = 1091,

[Description("Get file list as ADO.net DataTable")]
 GetFileListAsADONETDataTable = 1100,

[Description("Get folder list as ADO.net DataTable")]
 GetFolderListAsADONETDataTable = 1110

 

Numeric code for Action Property in Amazon Storage Task (S3 Actions)

[Description("Download Amazon file(s) to local directory")]
DownloadFileFromAmazon = 10,

[Description("Upload local file(s) to Amazon")]
UploadFileToAmazon = 20,

[Description("Sync Amazon file(s) to local (Compare by ModifiedDate)")]
SyncFilesFromAmazon = 22,

[Description("Sync Amazon file(s) to local with folder structure (Compare by ModifiedDate)")]
SyncFolderStructureFromAmazon = 23,

[Description("Sync local file(s) to Amazon (Compare by ModifiedDate)")]
SyncFilesToAmazon = 24,

[Description("Sync local file(s) to Amazon with folder structure (Compare by ModifiedDate)")]
SyncFolderStructureToAmazon = 25,

[Description("Delete Amazon file(s)")]
DeleteAmazonFile = 30,

[Description("Delete Amazon Bucket(s)")]
DeleteAmazonBucket = 40,

[Description("Copy Amazon file(s) to Amazon directory")]
CopyAmazonFileToAmazon = 50,

[Description("Move Amazon file(s) to Amazon directory")]
MoveAmazonFileToAmazon = 60,

[Description("Rename Amazon file(s)")]
RenameAmazonFile = 70,

[Description("Set Amazon file permission")]
SetFilePermission = 82,

[Description("Create new Amazon file")]
CreateNewAmazonFile = 90,

[Description("Create new AWS bucket")]
CreateAmazonBucket = 100,

[Description("Create new AWS bucket if does not exist")]
CreateAmazonBucketIfNotExists = 111,

[Description("Get Amazon file(s) size")]
GetAmazonFileSize = 1010,

[Description("Get Amazon file(s) exist status")]
GetAmazonFileExistsFlag = 1030,

[DescriptionAttribute("Get Amazon files count")]
GetAmazonFileCount = 1040,

[Description("Get Amazon file LastModifiedDate UTC")]
GetAmazonFileLastModifiedDate = 1050,


[Description("Get Latest file path (Sort By LastModifiedDate)")]
GetAmazonFilePathLatest = 1051,

[Description("Get Oldest file path (Sort By LastModifiedDate)")]
GetAmazonFilePathOldest = 1052,

[Description("Get Amazon file ContentType")]
GetAmazonFileContentType = 1060,

[Description("Get file Metadata in XML format (key/value pairs)")]
GetAmazonFileMetadata = 1070,

[Description("Get file text and save to Variable")]
GetAmazonFileDataAsString = 1080,

[Description("Get file bytes and save to Variable")]
GetAmazonFileDataAsBinary = 1081,

[Description("Get Amazon S3 file(s) Pre-Signed URL (Expires in 2 Days)")]
GetAmazonFilePreSignedUrl = 1082,

[Description("Get Amazon container exist status")]
GetAmazonBucketExistsFlag = 1090,

[Description("Get Amazon file list as ADO.net DataTable")]
GetAmazonFileListAsADONETDataTable = 1100,

[Description("Get Amazon file list as ADO.net DataTable (with PreSignedUrl)")]
GetAmazonFileListAsADONETDataTableWithPreSignedUrl = 1101,

[Description("Get Amazon folder list as ADO.net DataTable")]
GetAmazonFolderListAsADONETDataTable = 1102,

[Description("Get Amazon bucket list as ADO.net DataTable")]
GetAmazonBucketListAsADONETDataTable = 1110,

 

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/