We are starting to migrate to SQL 2K5 and I'm already disappointed in the
SSIS service. What I use to be able to do with a nice simple DTS package in
1 min now takes me 1 hour. I have simple needs; I want to copy approx 100+
tables from one database to another drop/overwrite all data, include all
indexes, defaults, constraints. Using the Import/Export wizard, the first
problem I ran into is that I must go into each table and specifically state
(*) Delete rows in destination table [x] Enable identity insert. This along
gives me great pain in having to do this in this manner. I have searched
various websites, newsgroups and while I have seen others post the problem
the only solution that was found was to manually edit the SSIS package code
and change the values to what I need them to be.

My Question: Is this truly the only way? Is there no way to tag all 100+
tables and say for all these tables drop/create and include the identity
field? I also have not found anything dealing with indexes? Where in the
Import/Export wizard or else where can you specify if the indexes are to be
copied?

I am very disappointed in the SSIS service and degree of difficulty I must
now go through in order to perform a simple task. Not to mention the
possibility of missing a table or two. I'm hoping someone can come up with
something I have just overlooked.

Sincerely,

David D. Cruger
Manager Technical Operations
JETNET LLC

You are not alone in feeling the pain in the Import/Export wizard or the
Transfer SQL Server Objects task.

In your case would a BACKUP/RESTORE be an option?

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"David D. Cruger" <David D. Cruger (AT) discussions (DOT) microsoft.com> wrote in
message newsC994E9C-39B7-4267-BA88-6F680EF65929 (AT) microsoft (DOT) com...

Allan;

Thanks for the suggestion and I'll give it a try.

Seems like this is a common theme for Microsoft. "Here look at all the
improvements we've made.." forgetting what really made the product to begin
with is now lacking in the newest release. More features does not a better
product make.

Thanks again; I'll see if the backup/restore can do the job.

David D. Cruger

==========================================


"Allan Mitchell" wrote: