question

neeraj1982 avatar image
neeraj1982 asked

I am unable to run ssis 2012 package from sql server 2017, I am trying to run it through sql 2017 agent job

I am unable to run ssis 2012 package from sql server 2017, I am trying to run it through sql 2017 agent job. error I am getting is

Description: Connecting to the Integration Services service on the computer "a--------xx" failed with the following error: "The specified service does not exist as an installed service.". This error can occur when you try to connect to a SQL Server 2005 Integration Services service from the current version of the SQL Server tools. Instead, add folders to the service configuration file to let the local Integration Services service manage packages on the SQL Server 2005 instance.

Please note I am trying to run it on schedule, rather than from start job in ssms.

sql server 2017ssis2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.