Post reply

Copy a SSIS package

  • May 26, 2011 at 9:55 am

    #240359

    Hi,

    I have created a SSIS package with around 40 data flow tasks.

    Now , I want to create the same package with just some minor changes.

    So i want to copy the previous package and paste it in new package.

    How is it possible

    Thanks

    Regards

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • May 26, 2011 at 10:05 am

    #1330464

    Open the package in BIDS, then File/Save a Copy ...

    Or just copy/paste the underlying .DTSX file.

    Check afterwards that the package IDs for the two packages are not the same (if they are, just generate a new one for the copied package).

    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

  • May 26, 2011 at 10:09 am

    #1330469

    Agreed with Phil. What you don't want to do it copy/paste the contents from the control-flow window into the other package.. There will be pain....

    CEWII

  • May 26, 2011 at 10:38 am

    #1330485

    I click on .dtsx file and copy

    but when i open another package

    i cant paste tht .dtsx file here.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • May 27, 2011 at 12:27 am

    #1330790

    SKYBVI (5/26/2011)

    I click on .dtsx file and copy

    but when i open another package

    i cant paste tht .dtsx file here.

    Regards,

    Sushant

    You copy the .dtsx files in the Windows itself.

    Then you go the the project in Visual Studio and add the copied package to the project. (Add existing item)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • May 27, 2011 at 1:51 am

    #1330804

    SKYBVI (5/26/2011)

    I click on .dtsx file and copy

    but when i open another package

    i cant paste tht .dtsx file here.

    Regards,

    Sushant

    Expanding on Koen's reply a little, SSIS packages are discrete dtsx files. What you tried to do is a bit like trying to paste an Access database into another Access database.

    Once you have a copy of the dtsx file, just open it in BIDS as usual - if you want it as part of your solution, just add it as you would any other package.

    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

  • May 27, 2011 at 3:50 am

    #1330846

    if you go the copy and paste route, then also make sure that you rename the object once you have add the copied version into BIDS.

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

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