Post reply

Execute more than one .dtsx in a solution

  • November 17, 2008 at 7:51 am

    #196363

    Hi All,

    Let me explain in brief about my package. StartUp package fetches an excel file from the FTP and the second package processes the excel file to a database. If I combine both the packages into one, there is an error saying that the destination file is not found, as that is fetching file from the FTP.

    I have 2 packages (.dtsx) in a solution. I had made one package as a STARTUP Package. But the other package is not getting executed.

    Can anybody suggest me an idea by which both the packages can be executed?

    any help greatly appreciated

    Thanks in advance

    Nithya

    Regards
    Priya

  • November 17, 2008 at 1:14 pm

    #899515

    Set DelayValidation = True on the bit that does the import.

    Surely your error is 'Source Not Found' rather than 'Destination Not Found'?

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • November 18, 2008 at 4:41 am

    #899780

    Hi,

    Thanks for ur reply.

    Let's say "pack1.dtsx" and "pack2.dtsx" are my 2 packages.

    I had setup "pack1.dtsx" as my startup package.

    This gets executed successfully. it stops after executing the first package without executing "Pack2.dtsx".

    Where should i want to specify the execution order of the package?

    Please help.

    Nithya

    Regards
    Priya

  • November 18, 2008 at 4:54 am

    #899786

    Now I see what you're asking.

    Well - you could create pack3.dtsx and in it create two linked 'Execute Package' tasks which execute Pack1 and then Pack2.

    Or ... you could go back to your first idea of a single package, which sounds like the way to go to me, and try to find out and resolve why it will not run.

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • November 18, 2008 at 5:09 am

    #899801

    Hi,

    Thank u very much for ur faster response.

    Combined both 1 & 2 pack into one.

    Changed the property (delayValidation = true) for Data flow task

    Now executed successfully..

    Thanks

    nithya

    Regards
    Priya

  • November 18, 2008 at 5:11 am

    #899804

    Excellent! Good to hear.

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 6 posts - 1 through 5 (of 5 total)

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