Upvotes: 3
<=-=Aug 23 2005 9:08AM=-=>
Does the table exist at the source? Is the table name correctly spelled? Do you have the package? If so, will you send it with the script to build the table you’re trying to transfer? Is this reproduceable with other tables? What version of SSIS are you using?
<=-=Aug 24 2005 2:12PM=-=>
Which version of SQL Server is being used? Probably if a newer version is used this problem may be solved.
This bug is not reproable as described. I need more info: Which version of sql server are used for source and destination? Are you choosing all tables, or a set of tables? Are you setting copy schema? … It is better to have the package attached. But I could copy a table from a source to a destination just fine.
<=-=Jan 18 2012 12:58AM=-=>
Please re-open.
This error msg shows when trying to copy an object that is in a schema different than ‘dbo’ (in source DB). It happens even if the ‘copy schema’ is set to ‘True’.
Here’s a query from SSIS that I’ve captured using Profiler:
SELECT
SCHEMA_NAME(tbl.schema_id) AS [Schema],
tbl.name AS [Name]
FROM
sys.tables AS tbl
WHERE
(tbl.name=N’MyTable’ and SCHEMA_NAME(tbl.schema_id)=N’dbo’)
SSIS version: 9.4.5057