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.
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.
answered Nov 30, 2009 at 04:24 AM