SQL Server Performance Forum – Threads Archive
can not open file
Hello, Using a foreach loop which contains dataflow. Inside dataflow there is a flatfile source. The following error is produced inthe flat file source. Error: 0xC020200E at Data Flow Task, Flat File Source [446]: Cannot open the datafile "EqRonnieHK". Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "Flat File Source" (446) failed the pre-execute phase and returned error code 0xC020200E. Please note, the file does indeed exist ThanksHave you checked the privileges for the user on that share or drive where this is located? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
When you are getting this error. Do you get this error when it is running fro, Visual studio or from SQL serve agent.
Where is this file is it in a remote machine. If your file is in remote machine and you have given UNC path, make sure that your sql agent user account has permission to the folder.
]]>