question about deploying SSIS

Question

Hi

 I have made a project of SSIS with VS 2022, and i need to deploy it and make it to be excuted once per day.

 It seems that I need to deploy it on sql server.when I click the property of the project ,in Target server version , the lowest is 2016, while i am going to deploy on sql server 2012. 

and when i right click property of the project,choose "deploy", in the step of "choose destination"(the translation of english  should be like that), i found that even i input the IP address of the database i want to deploy (sql server 2012), it shows"cannot connect"

i am wondering does it mean i am not able to deploy it on sql server 2012? Is there any other way that I can execute this SSIS project regularly like once per day?

Thank you very much

Answer 1

You can deploy the package to SSIS database or you can place the package in file sysetm, see

https://learn.microsoft.com/en-us/sql/integration-services/packages/deploy-integration-services-ssis-projects-and-packages?view=sql-server-ver16

Answer 2

SQL Server 2012, and its SSIS, is out of support by Microsoft. That's why latest VS2022 doesn't support deployment to SQL Server SSIS 2012.

You need to use (1) VS2019 and (2) its SQL Server Integration Services Projects extension for VS2019: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

Please see below what deployment options such setup supports.

Answer 3

Hi @Martin Wang,

You may also save the package on your local machine and then use agent job to schedule.

See How to run a local dtsx package within SQL Server Management Studio

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.