[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2007-08-05
Medium Priority
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

weellio earned 2000 total points
ID: 19635520

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?

http://technet.microsoft.com/en-us/library/ms137712.aspx more info

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

834 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