|
Home > Archive > MS SQL Server DTS > March 2006 > Copy SQL Server Objects task won't copy table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Copy SQL Server Objects task won't copy table
|
|
| Francis 2006-03-29, 9:29 am |
| I am using the Copy SQL Server Objects task in DTS on SQL Server 2000 sp4 to
copy a number of specific tables from one database to another on the same
server. The package fails with the error message "Could not find check
constraint for table 'x', although the table is flagged as having one."
Table x does have several check constraints defined. So do several other
tables being copied and they work.
Why can't the package find them? How do I fix this?
| |
|
| Hi Francis,
Create the script separately including all the options and launch it against
the target database using QA
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)
"Francis" wrote:
> I am using the Copy SQL Server Objects task in DTS on SQL Server 2000 sp4 to
> copy a number of specific tables from one database to another on the same
> server. The package fails with the error message "Could not find check
> constraint for table 'x', although the table is flagged as having one."
>
> Table x does have several check constraints defined. So do several other
> tables being copied and they work.
>
>
> Why can't the package find them? How do I fix this?
>
|
|
|
|
|