ssis

  • my ssis package(reading all log file in one folder) is excuted at the time one person already used one log file but i don't know.at the time my package was filed so pls how to solve this problem.

  • Subbu,

    Slow down, take a deep breath. Your post above doesn't make much sense but I'm guessing that's because you're typing quickly and in a bind.

    Take a moment. Think it through, explain what's going on and what you're looking for with us to help you.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • subbu.msbi (1/7/2011)


    I have developed one ssis package .one folder contain log file my package was reading one by one log files. suddenly my package was failed and i got below error message

    log file was used by another process .

    so pls how to solve this problem.

  • Hi,

    The issue is not other person open the log file which you try to open.

    1)If you write a log file for package execution result.and trying to open the file with the same package with different task Then its shows the file is used by another person.

    2)If its two different package and check the two package excuete at the same time.If package 1 trying to write a log in the log and same time pakage two try to retrieving the log file.

    To avoid make sure that package 1 complete fully.make package 2 as dependent on the package1.When package 1 get complete then pakage 2 get execute.

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

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