troubleshooting Question

SSIS Package Configuration Warning: Failure importing configuration file

Avatar of Mike Dwyer
Mike Dwyer asked on
Microsoft SQL ServerSSIS
7 Comments2 Solutions678 ViewsLast Modified:
I am seeing a strange behavior in my SSIS package when using a network UNC for my package configuration.  I’ve created a package configuration that looks to a network path for its configuration file.  When I try to run this package from the designer I receive the warning that the configuration file cannot be found and failure importing configuration file.  I’m using SQL Server 2012/ Sql Server Data Tools (aka BIDS).

When I store the configuration file on my local hard drive I get no warning.  When I map the network path to a drive letter and set my path to the drive letter I get no warning.  It’s only when I specify the path as a UNC.  
As a further test, I created a simple package with a package configuration pointing to the UNC.  I added a script task with some code that reads up the contents of that same config file specified as a UNC into a string variable.  When I run the package from the designer, I still get the warnings that it can’t find the config file –but- the script task can read the contents of that config file without a problem.
This is a new one for me.  Has anyone seen this behavior before?
ASKER CERTIFIED SOLUTION
Mike Dwyer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros