Hello! I apologize in advance if this has been asked, but I have not been able to find an answer and I'm semi new to this.
I'm editing a package that is deployed SQL Server 2016 with Visual Studio 2015 and have a bunch of errors saying File/process "XXXX" is not in path. I know these paths exist on the server that I'm deploying to, however I'm editing on my computer so it isn't finding it.
Can I deploy with the errors there or how do I get them to go away and work correctly once deployed?
asked Jan 11 at 05:54 PM in Default
Without knowing the details we can only guess what may be the issue. But if there are file connections in the SSIS package, then you would have to edit those connections as per your environment. Moreover, it is the best time that you change your connections strings being driven dynamically through package variables.
answered Jan 12 at 02:24 PM