How to create folder in Amazon S3 Bucket using SSIS

There will be a time that you like to create an empty folder in S3 bucket using SSIS Amazon Storage Task. You would be surprised to know that Amazon S3 File System has no concept of folders or files. S3 System is nothing but Key/Value Pairs. Key is typically your path (slash is used to indicate path) and value is your file data. Its up to client app to represent Key into some nested looking structure which feels like real file system :).

So in other words folders are virtual in S3 files system navigation. Using slash in path will show Folder automatically in some tools or S3 Browser in AWS console.

However if you really want to have a folder which is always there even no file under that folder then use below technique.

1. Assuming you already installed SSIS PowerPack
2. Open SSIS Package.
3. Drag and drop ZS Amazon Storage Task from SSIS Toolbox.
4. Open Amazon Storage Task like below. As you see we used Create new Amazon File action. Target path must end with slash. Any S3 Key ends which ends with slash is treated as folder in Client Tools like below App (We use Cloudberry S3 Browser)
5. We used Source content from some Empty variable (used {{System::VersionComments}} because its mostly empty ). Leaving this field blank cause Validation warning so must use something there.

Hope this helps

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/