question about deploying SSIS

Martin Wang 106 Reputation points
2024-05-21T07:22:16.6666667+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,485 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 42,381 Reputation points
    2024-05-21T09:16:53.9133333+00:00
    0 comments No comments

  2. Yitzhak Khabinsky 25,376 Reputation points
    2024-05-21T12:33:10.04+00:00

    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.

    SSIS - TargetServerVersion_2

    0 comments No comments

  3. ZoeHui-MSFT 34,576 Reputation points
    2024-05-22T02:53:19.44+00:00

    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.

    0 comments No comments