| gary@gaelmart.com 2006-03-30, 8:27 pm |
| Hi
Nobody ever gets an answer to this. I spent the last 3 days looking!
So I thought I'd try as it no doubt affects millions who host online
databases.
When you make an SQL 2005 SSIS Package to simply download a table (or
any object) from a web hosting for example like we've done for years
with DTS 2000, there seems to be a bug which forces an sql statment
like below.
SELECT SCHEMA_NAME(tbl.schema_id) AS [Schema], tbl.name AS [Name] FROM
sys.tables AS tbl WHERE (tbl. name=N'ts_BCat_BSect
' and
SCHEMA_NAME(tbl. schema_id)=N'usernam
efam')
The trouble is the
'(tbl. schema_id)=N'usernam
efam')'
should be
(tbl.schema_id)=N'dbo')
And so you recive the error
[Transfer SQL Server Objects Task] Error: Table "ts_BCat_BSect" does
not exist at the source.
Its getting the usernamefam from my login I know but how do I either
get it to use dbo OR
change my table from
dbo.Mytablename
to
usernamefam.Mytablename
I don't have permission to run ALTER SCHEMA
but I used to be able to change who owned a table with sql 2000 no
proplem.
If I get this sorted, we'll move onto the 'Table has to exsit if you
select DropObjectFirst; option problem.
Cheers
Gary
|