Hey all,

I just made a post on this: http://www.sqlservercentral.com/Forums/Topic999289-391-1.aspx and while it's good to know it's resolved with 2008 SP2 ... the issue is still very much so present in...

Usually easiest way is to do a...

In the data conversion step, it's set to "unicode string [dt_wstr]" 4000. I tried to change to 8000 and it says values must be between 0 and 4000. Which data...

stewartc-708166 (8/11/2010)

---

Excel works with the Unicode character set.

The maximum size of a unicode column is 4000 bytes

If you check the datalength of the column, are there records that do indeed...

Disregard, I'm a big dummy ... public network was down.

Actually ... I'm thinking it may be because the DTC resource is offline due to a duplicate IP conflict. Yet I don't understand how DTC plays a role as I...

haha, nevermind ... finally did find it. I am in a group which is in another group that has default database access to this database.

Nice.

Still never figured anything out on this one ...

Amol, I ended up doing the same thing to resolve this. Never found any other resolution.

Thanks for the feedback.

Forgot about this issue and never found resolution to it ... hoping to catch someone's attention on this.

Thanks

I am hoping to build a TEST environment in the near future to give this a shot, but just curious to as if anyone has this in play and what...

Just as an FYI ... found it hiding in the properties window under labels.

Well, the removal of the symantec product also removed the instance, so I'm good to go.

bp, not sure I follow you, but are you basically saying you're having the same issue?

Hate to bump my own thread, but still have not found resolution to this.

Thanks