Post reply

Execute multiple configurations file in Execute Package utility

  • November 13, 2006 at 11:41 pm

    #367994

    Hai to all

         I have package which imports textfile into SQLServer database. There are multiple config files , each having a unique path for text file.

     I need to execute all these config files in ExecutePackageutility. I added the config files in this utility through ADD button and executed.But the configuration file that has been loaded last is executed and only that text file is imported.

       How to execute all multiple config files?

    Pls help me if anybody knows the solution.

    Thank you

     

      

  • November 16, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • November 16, 2006 at 9:48 am

    #672359

    Nirmala

       From what I can see is that all of the configuration files are all set when the package loads.  This is the reason that the last configuration is the one that is being used by the execution.

       You could execute the package multiple times passing the specific configuration file each time (SQLAgent, DTExec, manually, etc.).

       I would think that you best solution would be to implement the package using a ForEach Loop Container that would iterate through each of the files to be processed.

        Rick

     

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

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