We help IT Professionals succeed at work.

Schedule SSIS package in WIndows Task Scheduler

3,486 Views
Last Modified: 2017-03-08
On an AWS EC2 server (Windows Server)
I need to set a once a day task to run a DTS Package.
Comment
Watch Question

Systech AdminChief Technology Officer
CERTIFIED EXPERT

Commented:
Larry Bristersr. Developer

Author

Commented:
There is no DTExec.exe in that folder path

SP.png
Systech AdminChief Technology Officer
CERTIFIED EXPERT

Commented:
what version of SQL you are using?
Larry Bristersr. Developer

Author

Commented:
2014
Systech AdminChief Technology Officer
CERTIFIED EXPERT

Commented:
Have you installed the SQL  integration services?
Larry Bristersr. Developer

Author

Commented:
Gaurav
This is an Amazon EC2 Instance.

I have the SSMS Console installed but no specific instance of a SQL Server Database.

How would I go about this.

We are using an RDS Server on another EC2 instance.
Chief Technology Officer
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Larry Bristersr. Developer

Author

Commented:
Perfect
Thanks