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

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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