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

avatar image

Mansour Shoari
435 14 17 20

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

avatar image

Håkan Winther
16.6k 38 46 58

(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Nov 30, 2009 at 01:10 AM

Seen: 1009 times

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

Copyright 2018 Redgate Software. Privacy Policy