SSIS RDS - Dynamic connection to S3 buckets

0

We had SSIS packages that were using File System and we are planning to change it to use S3 buckets . So used a third party tool - Zappysys for taking care of this task to access / move / process with S3 buckets . It was working fine . We are also having a plan to move SSIS packages to RDS Server - then we started checking and it showed up a lot of tasks which isn't supported in the RDS - like script tasks or script components . We did change or found a solution to handle those logic by avoiding script tasks or components . Now - we have the hurdle of connecting SSIS RDS packages to S3 buckets - which are dynamic by env and by client . Would like to know if there are services that can take care of this from the SSIS packages which are in RDS server or does AWS provide option to open up to use third party tools .

1 個回答
0

While RDS does not allow direct integration with multiple S3 buckets, you could consider Glue jobs for this scenario.

Schema Conversion Tool (SCT) provides an SSIS package conversion option that can be used a starting point.

This blog post might help.

AWS
已回答 10 個月前
  • Thanks Adrian will check this

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南