ANY way to save the queries in the SQL 2005 Server Import And Export Wizard?

Posted on 2007-08-05
Last Modified: 2013-11-30
Is there ANY way to save the queries in the SQL Server Import And Export Wizard for SQL2005 Server?
In Enterprise Manager, you can save an export for use later.  With 450 tables, and 3 hours of clicking, I'd love to be able to save like I used to.

Question by:bd9000
    1 Comment
    LVL 19

    Accepted Solution


    Save and run a package.
    If the wizard is started from SQL Server Management Studio or the command prompt, the package can run immediately. You can save the package to the SQL Server msdb database or to the file system. When you save the package you can set the package protection level, and if the protection level uses a password, provide the password. For more information about the msdb database, see Managing Integration Services Packages.
    If the wizard is started from an Integration Services project in Business Intelligence Development Studio, you cannot run the package from the wizard. Instead, the package is added to the Integration Services project from which you started the wizard. You can then run the package in Business Intelligence Development Studio.

    although you just want to save the quesries, not the entire package.. hmm,.

    i currently dont' see an option. posibly it isn't configured  by queries, just object manipulation? more info

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now