SSIS - Wizard vs manual vs programming

Posted by alchemical on Stack Overflow See other posts from Stack Overflow or by alchemical
Published on 2010-02-04T00:23:38Z Indexed on 2010/04/27 16:23 UTC
Read the original article Hit count: 548

Filed under:
|
|

I'd like to move 26 tables from one DB to another. I see I can do this in the SSIS Import and Export Wizard. I believe the other approach would be to select tools from the toolbar in Data Flow and then configure them all.

When is it better to use the wizard and when is it best to create the package manually (with the visual tools) or programmatically? One thing I noticed with the Wizard is that it lets me select multiple tables at once, but I could not find a way to get back to that screen once the package is created, so that I could edit the various tables all in one place.

© Stack Overflow or respective owner

Related posts about ssis

Related posts about dtsx