how to move a SSIS package in our automation process

Accepted answer

Hi Amudhan,

I understand that, you want to automatically execute your package everyday. If so, you should create the JOB in service agent.

Follow the link for your reference.

https://www.c-sharpcorner.com/article/load-data-from-database-to-text-file-using-ssis-package/

Thanks.

And, you can use the following link to create JOB for the SSIS package.

https://www.c-sharpcorner.com/article/create-a-job-in-sql-server/

Thanks.

thank you

What type of deployment do you have?

1- SSIS File base deployment (old school)

Answer: is a simple copy and past becasue its a file

2- Catalog Deployment (SQL2012+)

Answer: you will have to deploy the packages to a SSIS services that saves the SSIS packages in a XML format within database called SSISDB

SO

First question is how are you deploying your packages and how are you calling them?