x

Need for a [Back] button when “Import Data” is successful in SSMS

Good day, In SSMS’s “Tasks > Import Data” wizard function, when one goes through all the steps of selecting data and table source/destination, and successfully imports the data into SQL, he would get the famous “The execution was successful” message. Understanding that this is the end of the requested job in the SSMS, the “close” button would be a logical end for the process.

However, sometimes one has multiple data tables from a specific source to import to a specific destination and likes to import them one by one in a certain order to full fill the dependency requirements etc (i.e. FK data). Wouldn’t the implementation of a [Back] button be helpful in that step? Currently one must close the “successful execution” confirmation box and go back to start the process all over again for importing data table 2, 3, 4, etc. (and the “last selected options” in the wizard steps don’t get “auto displayed” to ease the recurring processes either). Than-you.

more ▼

asked Nov 30, 2009 at 01:10 AM in Default

Mansour Shoari gravatar image

Mansour Shoari
435 14 14 16

This sounds like a feature request to me, and not a SQL server question?
Nov 30, 2009 at 04:26 AM Håkan Winther
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

The best solution to this is to click the "Save SSIS package" checkbox and click Finish to save a SSIS package that you can execute for the following tables.

If the tables are depenedent on each other, then I would modify the SSIS package so that everything i imported in a workflow with transactions and error handling.

Another feature that is useful if you create a SSIS package is that you have the possiblity to use "Fast load" to import a file with a fixed batch size, like 1000 records at a time.

more ▼

answered Nov 30, 2009 at 04:24 AM

Håkan Winther gravatar image

Håkan Winther
15.7k 35 37 48

Thanks, Hakan. Yes, you are right, this is maybe a feature request for the next release of SQL. SSIS is a definite answer. However, sometimes the job is so small that you rather go through the wizard's clicks than modifying SSIS and reruns etc.
Nov 30, 2009 at 09:54 AM Mansour Shoari
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x6

asked: Nov 30, 2009 at 01:10 AM

Seen: 811 times

Last Updated: Nov 30, 2009 at 04:25 AM