SQL Server Integration Services
You'll need to open the package in Business Intelligence Dev Studio.
Why can you not change these things in SSIS Designer (i.e. BIDS)
It would be easier for you to set these options in the wizard. On the page where you selected tables to transfer, click "Edit..." for the ones you want to change the options. You will see appropriate radio-buttons/checkboxes, for the options you mantioned, in the window launched by the "Edit..." button.
In the SP1 version of the wizard you will be able to bulk-edit these options without multiple clicks on the Edit button.
The package generated by the wizard is kind of complicated (if "Optimize for many tables" is specified). It generates and executes a small packages that transfer single tables. There is an XML file that feeds this package generator, but it would not be easy to modify that one because it contains actual drop or truncate statements.
For 80 tables you might try to uncheck the "Optimize for many tables" checkbox. That will create the package with 80 parallel data flows. It will make the things more clear, but you would still need to set you drop table or truncate table statements as appropriate in the Execute SQL Tasks before the Data Flow.
Yes, you found the right property for the Keep Identity setting.
I do not know the official dates for SP1, but you should not have to wait too long.
Mike C wrote:
How do you go back and edit a package created by Import and Export Wizard assuming I'm in the Designer. How do I find the SQL Script that was generated so I can edit it
There's an option at the end of the wizard to save as a package. Just do that and edit it using BIDS.
Could someboday please offer some advice how I can edit the package that the import export wizard creates.
Specifically how to add or remove a table that was not included originally while running the wizard
It looked like it was possible to edit TableSchema.xml but that is unavialable.
It SSIS seems like a great tool, and I wish I had more time to learn how to use it.. But at the moment I just need to be able to get a population of tables copied from production to test, those tables may change, or they may throw vaildation errors which I need to fix but I dont time to select the 200 some tables we need each time I run a test copy, as Import Export wizard provides no back button after an export attempt.
If it cant be done please let me know that too, so I don't waste any more time looking for a solution thats not there. If I have to do a database copy or create a BCP script then I need to get started on it right away.
unfortunately there is no way to restart the wizard from the package it produces.
You only have options of manually tweaking the produced package or regenerating it again. By looking at the package it should be relatively simple to add/drop a few tables, if it is a small number.