SSIS File System Task - Create Folder - "The network path was not found"

1.8k views Asked by At

I've recently created an SSIS Project and deployed that project to a folder in SSISDB. I've tested this project and I am able to run it end-to-end in Visual Studio successfully.

However, when I run the deployed version I get an error: "The network path was not found". I view the reports of the execution and notice that it relates to the File System Task; specifically I configured it to create a new folder and I configured the Source Connection as a File Connection in the File System Task editor.

So in my Connection Managers window I have 3 connections:

  1. SQL Server
  2. Excel
  3. File Connection (used in File System Task; basically the directory I want the Folder to be created in)

I've noticed that 1 and 2 are deployed to SSISDB but not 3. I'm guessing this is the cause of my problems. Question is why is 3 (the file connection) not deploying to SSISDB? I have no clue. I've searched around and tried different things.

Thanks

PS- Connection Manager enter image description here

0

There are 0 answers