CODEWITHSUNDEEP
sql-serverssisamazon-rdsdtexec
ArunKumar
ArunKumar

Reputation: 1

Executing SSIS Package from File System

We execute SSIS package using below command written in a batch file. (On premises MSSQL DB) D:\Program Files\Microsoft SQL Server\130\DTS\Binn\DTEXEC.exe>" "E:\Packages\SSISPKG1.dtsx" /Config "E:\Packages\Config\config.dtsConfig".

Now we migrate to AWS RDS-MSSQL service. How to execute .dtsx file stored in S3 bucket. What is the path of DTEXEC.exe for RDS - MSSQL. (Microsoft SQL Server)?

As I am assuming, RDS-MSSQL Service create an hidden EC2 instance for processing and storing data. Is it possible to create a folder on that instance to keep .dtsx file and run a batch file when needed?

Upvotes: 0

Views: 1747

Answers (1)

Piotr Palka
Piotr Palka

Reputation: 3169

RDS supports only project deployment mode. There is a tutorial:
Using Microsoft SQL Server Integration Services on Amazon RDS for SQL Server

Upvotes: 0

Related Questions