Post reply

Cannot open the data file error

  • October 6, 2008 at 1:33 am

    #382943

    Hi,

    Get the following error when manualy executing the package from BIDS. I've tried renaming the file, creating a new file all with the same result. Also checked the "user" access. Please help.

    Warning: 0x80070020 at Data Flow Task, Flat File Destination [2842]: The process cannot access the file because it is being used by another process.

    Error: 0xC020200E at Data Flow Task, Flat File Destination [2842]: Cannot open the datafile "D:\Homeloans data\Inputew_data1.txt".

    Error: 0xC004701A at Data Flow Task, DTS.Pipeline: component "Flat File Destination" (2842) failed the pre-execute phase and returned error code 0xC020200E.

  • October 6, 2008 at 3:09 am

    #881002

    are there any other tasks in your workflow that may have a hold of the file? perhaps a file system task that has copied off the file and you are accessing the copy?

    tom

    Life: it twists and turns like a twisty turny thing

  • October 6, 2008 at 4:59 am

    #881027

    The package was a flat file to flat file which just stopped working with the error mentioned. I've tried creating a complete new package with new files, with the same result. I've now changed it to import the data from the flat file into a database and from the database back to a flat file and this works like a charm.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply