Adding files of a SSIS package to another SSIS package

  • As i told in description i have two SSIS packages P1 and P2. P1 has one DTSX and P2 has three DTSX files.

    i want to add P1's dtsx file to P2 package.

    I copied dtsx and sln files from P1 to P2 and i opened P2 package bur that newly added dtsx filke is not included.

    I am not sure what files to move and how to move so that i want to see P1's files in P2 package.

    Please help me out

  • I am guessing P1 and P2 are really solutions(and not packages), because the statement :

    P1 has one DTSX and P2 has three DTSX files.

    doesn't sound right. One SSIS package always has one dtsx file.

    Now if you want to add solution P1's dtsx files to solution P2, you can do that as follows :

    Go to directory of P1 solution. Copy the dtsx you want.

    Go to directory of P2 solution and paste the copied file there.

    Open P2 solution

    Right click the SSIS packages node and click 'Add Existing Package'

    Locate the file in the P2 directory (this is the file you just copied) and add it.

    The copied package should become be in the current solution now.

    The other way to do that is :

    Open P2 solution.

    Go to File --> Open

    In the OpenFile dialog box, locate the file in the P2 directory (this is the file you just copied) and add it.

    The new package is opened. BE AWARE though, that this file is still not a part of your current solution. For doing that, just go to

    File --> Move 'copiedpackage.dtsx' into

    and choose the current solution. This will make the copied file a part of your current solution. You can now close the opened file and open it again from the actual SolutionExplorer window.

    Hope this helps.

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

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