Open Import/Export Wizard in BIDS

  • Regarding the method for OPENing Import/Export Wizard in BIDS ... Wrox book "SQL 2005 Int Services" Chap. 2 1st page states "You can also open the Import/Export wizard by right-clicking SSIS Packages in BIDS and selecting SSIS Import and Export Wizard"

    Can some one point out where "SSIS Packages in BIDS" is -- I don't see it?????

    BT
  • You have to have a solution open before you can find it.  Then look in Solution Explorer, you'll see the project name and 3 folders underneath it.  Data Sources, Data Source Views and SSIS Packages.  Right-click THAT SSIS Packages and the Import / Export Wizard is the second thing on the list.

     

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • If you don't want to open BIDS, you can run this by right-clicking on a database name in SQL Server Management Studio, then choose "Tasks" then "Import Data" or "Export Data".

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

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

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