Post reply

Metadata inconsistencies for flat file connection object

  • October 6, 2008 at 7:46 am

    #154789

    I am having a problem with gaining access to a flat file via a connection object. The object is using a path which I need to change. When I change the path in the connection object it appears to be changed in design time but when I run the package there is a failure gaining access to the particular flat file due to the path in run time. It appears the connection object refers back to the original path and is causing the failure. To me this appears to be some sort of caching or metadata issue. Does anyone know how I can change the metadata to reflect the correct path during run time? Or if you think this could be a different problem completely please advise. See my error below:

    [input file [671]] Error: Cannot open the datafile "\\MyServer\MyFolder\MySubFolder\MySubSubFolder\My_Input_File.txt".

    The path should be:

    E:\MyFolder\MySubFolder\MySubSubFolder\My_Input_File.txt

  • October 6, 2008 at 9:22 am

    #881152

    is the connection string for the flat file connection constructed using an expression?

    Life: it twists and turns like a twisty turny thing

  • October 6, 2008 at 10:32 am

    #881220

    No it was simply typed in no expression -- Thanks for your response but I just resolved the issue by creating a new connection manager object. I guess I still don't know how to adjust the metadata if that is the issue but as most projects I am on a deadline so needed to move on. If you know how to do this I would appreciate your response.

    Thanks,

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

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