Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SQL Import and Export Wizard - Is there an update mode?

Answered SQL Import and Export Wizard - Is there an update mode?

  • Saturday, December 29, 2012 1:44 PM
     
     
    Sign In to Vote
    0

    It seems that SQL Import Export Wizard only has a 'create' mode.   Once the project has been created and saved, it cannot be changed unless you manually edit the Project XML with Notepad or similar program.

    Is this correct?   If so, why does it not have an 'update' mode?

    Thanks

    Tom

    MisterT99

     

All Replies

  • Saturday, December 29, 2012 9:20 PM
    Moderator
     
     Answered
    Sign In to Vote
    1

    you can save SSIS package at last steps of Import and Export wizard

    and then with SSDT in 2012 or with BIDS in 2008,2005 open SSIS package inside an Integration Services project with Add Existing Package

    and then you can edit it there

    http://www.rad.pasfu.com

    • Marked As Answer by Mister T99 Saturday, December 29, 2012 11:01 PM
    •