Flat file reading through script component with vb

  • I have bunch of 100 logfiles in a location.I need to load one by one .I am using the foreachloop container with flat file connection manager.The problem here is if a Flat file source editor try to open a file which is opened or opened for writing the Package fails.So any one can suggest how to overcome this issue.Is there any Readonly properties like that available in the flat file file connection manager or flat file source editor so that it won't fail?.Need to load the file but REad the file in readonly mode eventhougth it is been blocked for Writing.

    Thanks

    Sundar

  • What kind of log files? Can you post a sample name for the log file?

    I take it that an application would have these files open, rather than a person? If so, it would only have the most recent file open, correct?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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