• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 127
  • Last Modified:

ssis sql server 2016

What all needs to be installed on a sql server 2016 to run ssis packages from the server using a network account?  We've installed 2016 and ssis, when trying to run visual studio 2012 packages that were rebuilt in visual studio 2015 we're getting an error: if you want to run package out side of sql server data tools you must install ssis standard or above.  we've installed ssis enterprise on the server and are trying to troubleshoot the configuration or compatibility issues in order to run the package(s) on the sql 2016 ssis server.
0
conardb
Asked:
conardb
  • 2
2 Solutions
 
ste5anSenior DeveloperCommented:
How do you deploy your SSIS packages?
0
 
conardbAuthor Commented:
I developed in visual studio, saved the package, imported the package into the ssis server file system option, and tried to execute.
0
 
conardbAuthor Commented:
errors attached
ssis-server-errors.docx
0
 
funwithdotnetCommented:
I see a permission error as well as the missing SSIS error. Something's weird because I can see the SSIS installation in the permission error screenshot.

Perhaps you should address the EXECUTE permission issue and proceed from there.

Good luck!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now