hi, i am getting foloowing error: Error: 0xC020200E at Data Flow Task, Flat File Source [76]: Cannot open the datafile "C:\Users\emp.txt". Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: Flat File Source failed the pre-execute phase and returned error code 0xC020200E.

Error: 0xC020200E at Data Flow Task, Flat File Source [76]: Cannot open the datafile "C:\Users\emp.txt". did you see anything locked on it..?Thanks, Rama Udaya.K "You only live once, but if you do it right, once is enough. Mae West". ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

how to see it

download the exe http://technet.microsoft.com/en-in/sysinternals/bb896653.aspxThanks, Rama Udaya.K "You only live once, but if you do it right, once is enough. Mae West". ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

Hi Did you downladed and checked is there any processes locked that file.. even this type of an issue occurs not only this even other as well but please check to ensure no processes locked it...Thanks, Rama Udaya.K "You only live once, but if you do it right, once is enough. Mae West". ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

Some obvious questions: is the flat file present at the location?do you have permission to open it?MCSA SQL Server 2012 - Please mark posts as answered where appropriate.