Post reply

Execute more than one .dtsx in a solution

  • 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

  • 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

  • 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

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

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