Errors using UNC paths with SSIS

Posted on 2014-07-16
Last Modified: 2016-02-11
I have an SSIS package that works if run manually but when put into a job fails with the following message.

"Description: The file name "\\fileprint\ITDepartment\ToExport\PriceChanges\Pricechanges.csv" specified in the connection was not valid."

However I have a drive mapped where G: is equal to \\fileprint\ITDepartment (i.e. G:\ToExport\PriceChanges\Pricechanges.csv) and it works OK.  Is there a trick to using a UNC path with SSIS?

Thanks for the ideas
Question by:jdr0606
    LVL 65

    Expert Comment

    by:Jim Horn
    >when put into a job fails with the following message.
    If you're deploying it to a server, then any paths need to be valid on that server.

    >Is there a trick to using a UNC path with SSIS?
    Nope, although it may be a deal where if you start up the server and run a job with that path, it fails, whereas if you click on the path in Windows Explorer and it works, then run the job and the job works.  No idea why that's happening.
    LVL 11

    Accepted Solution

    I suspect one of the following:


    Put \\fileprint\ITDepartment\ToExport\PriceChanges into Windows-Explorer, are you able to see the file Pricechanges.csv?  I like to use *cough*DOS*cough* to tell me exactly what are my drive mappings by issuing net use.


    Which credentials are running your SSIS-package?  If you are using a SQL Server only-user then it cannot see any file-system except the server where it resides.  If you mapped a SQL Server user to an active-directory service-account then that service-account must have access to that folder structure.

    Author Closing Comment

    I was related to credentials and access to the folder on the network. The error which was thrown by the SSIS package noting that it could not find the file was simply because it didn't have permissions to the folder where the file was located.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now