SQL Server Performance Forum – Threads Archive
can not open fileHello, 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 : 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 Thanks
Have 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.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.