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
Author
Message
Posted Wednesday, September 11, 2013 1:36 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 14,433, Visits: 12,418
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 LessThanDot.

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, June 26, 2015 6:21 AM
Points: 28, Visits: 604
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