question

Mansour Shoari avatar image
Mansour Shoari asked

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.

sql-server-2005feature-request
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Håkan Winther avatar image Håkan Winther commented ·
This sounds like a feature request to me, and not a SQL server question?
1 Like 1 ·

1 Answer

·
Håkan Winther avatar image
Håkan Winther answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.