Post reply

Errors in Package Execution

  • November 17, 2014 at 5:04 am

    #150790

    I asked recently about importing flatfiles dynamically but after a fair bit of research I finally decided that the easiest way would be to create a package per file and run them individually. I then decided to try and run all the packages using a Foreach container and an Execute Package Task. I figured it was theoretically possible and I'd done a bit of research to suggest it could be done. I'm now having a problem with my flatfile connection.

    When I execute an individual package on its own it runs fine but when I attempt to run it from my master package it fails. If I attempt to execute the task outside the container I get the error:

    ' Error: Error 0x80070002 while loading package file "C:\myFolders\myFile". The system cannot find the file specified.'

    This happens even when I set the file name manually on the Flatfile connection. When I attempt to run the task in the container it fails with the message:

    [Connection manager "My Connection.dtsx"] Error: The file name property is not valid. The file name is a device or contains invalid characters.

    Research has suggested it's a permissions issue but I can't see how this is the case here because I'm executing everything in the same instance of SSIS, sometimes with both the parent and child packages open next to each other. The child package will run in isolation but won't when run from the parent. I'm stumped.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • November 17, 2014 at 7:31 am

    #1758980

    put in some breakpoints and examine the variables used to set up the file names just before the failing operation executes. That should give you clues.

    Gerald Britton, Pluralsight courses

  • November 17, 2014 at 7:33 am

    #1758982

    It depends on how you are setting the file name for the connection manager. Doing multiple packages you may not have changed where the file connection is looking at originally. So when the package opens up and validates it may not find the file. You may set the file name later in the package before the data is moved. If this is the case you need to look at the properties of the file connection and change Delay Validation to 'true'

    E

    🙂

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

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