Is this a bug or am I going (gone?) mad...
Using a simple OLE DB Source and SQL Server Mobile Destination SSIS objects,
I want to copy data from a varbinary(8000) column over from a SQL 2005
database to my target .sdf database. The data is truly variable length, but
the confounded data flow always copies 8000 bytes into the mobile database.
There is no way to trim this data either during or after the copy process (or
none that I have found), so basically the database is no longer useable and
extreamly bloated. Was this the intention or is this a version 1.0 bug? If
the latter (and I can't beleive that MS wanted it that way, so it MUST be a
bug) is there a fix... or a workaround... or anything?
Best regards