Is it me or a lot of the tasks in SSIS do not works the way they
should.

I first tried to use the Transfer Database Tasks it never works I keep
getting "user already exists" error. After a few attempts trying
different things I gave up on that task.

Then I try the Transfer SQL Server Object Task. I have many DBs to
transfer:

- One fails on Cannot insert duplicate key in object (Primary Key
violation) even if I specified replace existing data.

- the other fails on "User 'ReportsApp' does not exist in the current
database."

- then on another DB, I tried to SQL Authentification instead and then
I get: Cannot apply value null to property Login: Value cannot be
null..".

I got lots of other errors that I can't even remember.

My goal is to go from sql2000 to sql2005 but I am also trying to do
sql2000 to sql2000.

Once again, Microsoft was able to put a tool that look exiting on the
demos but does not ANYTHING easy. We will ALL waste our time trying to
get it to work.

SQL 2005 IS NOT GOOD!!!