Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: Yesterday @ 1:36 PM
Points: 14,737, Visits: 12,831
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: Thursday, October 1, 2015 1:48 PM
Points: 28, Visits: 627
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