Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

SSIS : Cannot open the datafile Expand / Collapse
Posted Wednesday, September 11, 2013 1:36 PM



Group: General Forum Members
Last Login: Today @ 5:34 AM
Points: 15,443, Visits: 13,145
Does the SQL Server Agent account have permissions to open the file? Or are you using a proxy?

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1493877
Posted Thursday, February 5, 2015 9:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, October 21, 2016 7:00 AM
Points: 32, Visits: 757
I had this error. In my case, I had the wrong selection in the For Each Loop container. Under collection there are three options:

name and extension
fully qualified
name only

I made changes to a variable, and that impacted how the loop was reading the file name. After I updated the For Each Loop option, my package worked without an error.
Post #1657999
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse