x

SSIS and SQL Server 2016 - File/process is not in path

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?

more ▼

asked Jan 11 at 05:54 PM in Default

avatar image

tj13
1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jan 12 at 02:24 PM

avatar image

Usman Butt
14k 6 13 21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1231

asked: Jan 11 at 05:54 PM

Seen: 14 times

Last Updated: Jan 12 at 02:24 PM

Copyright 2018 Redgate Software. Privacy Policy