I have a line of business application that the company decided to disable (valid license purchased but now it's old so they just disabled the authentication system, leaving me without ANY of my data in an accessible format). They sent me a link to just use SQL Export Wizard to get it into Access or Excel (I chose Access). Anyway, There are about 750 tables and the export wizard fails with the following message:
Could not connect destination component. Error 0xc0204016: SSIS.Pipeline: The "output column "Printitem" (655)" has a length that is not valid. The length must be between 0 and 4000.
I was able to step through some of this by finding the table with the offending column but this is EXTREMELY tedious and I still have over 600 tables to work with!
Is there a way to globally fix this? I have "Ignore" selected on conversion errors but it still fails. Worse, yet, the error message does not include the offending table name! So I have to try to find it (even more tedium).
HELP, Please. I'm not a DBA.
Note: I did track down this column in a table. It's a VarChar field 9n SQL Server, being converted to LongText in Access .mdb format. Funny thing is, there's NO DATA in this table!