Our company has just switched from SQL 2000 Enterprise Manager to SQL 2005 Server Management Studio. My problem is when I try to import or export certain tables I get the error message below. But when using SQL 2000 EM there is no problems or issues.
I am exporting tables from SQL 2005 to a blank Access 2000 db. If I use SQL 2000 EM, exporting the same tables it works just fine. The error indicates that there is a length limitation of 4000. I know it's not the blank Access db because I've confirmed that Access 2000 can go up to 63,000 or so.
Is there a setting within SQL 2005 that needs to be adjusted to allow tables over 4000 in length. The tables I am having trouble with shows 8,000 length. I also have the same problem with Importing.
I've tried Importing / Exporting from both the server itself and remotely with the same failed result.
This has had to of happen to others right? I hope someone can help! Below is the error message.....
Could not connect destination component.
Error 0xc0204016: DTS.Pipeline: The "output column "Facts_of_Case" (1657)" has a length that is not valid. The length must be between 0 and 4000.