Hi
First don't respond unless you've actually tried this.
I'm fed up hearing bull about SSIS being more powerfull than the old
DTS.
For weeks now I've trying to find out how to to upload tables to CT.
That it, no fancy stuff.

In old DTS(in the export wizard) I clicked the Select Object buttons
and selected Transfer foreign keys etc.

I can find these same options in SSIS so no problem there BUT it all
fails because if you look at the SQL(in profiler) that actully gets run
the owner name is used in the sql e.g.

Uploading tables
WHERE (tbl.name=N'MYbigTable' and
SCHEMA_NAME(tbl.schema_id)=N'MYUSERNAME')

Dowloading tables
WHERE (tbl.name=N'MYbigTable' and
SCHEMA_NAME(tbl.schema_id)=N'DBO')

Error

[Transfer SQL Server Objects Task] Error: Table "MYbigTable" does
not exist at the source.

If I could get the SCHEMA_NAME(tbl.schema_id)=N'DBO') out of the
equation all would work.


We have 60+ sites which we need to manage.
Old dts, no problem. 4 clicks and your done.
New SSIS, we can't be dicking around for hours creating scripts for
each table.

Please even respond even if your in the same boat as its begining to
look like some embarising problem no one likes to talk about.

Cheers

Gary