See if this post helps: http://www.sqlservercentral.com/Forums/Topic341391-149-1.aspx

I...

The purpose of CDATA is to instruct the XML interpreter that everything within it should be treated as character data, and not markup. The CDATA tag still must contain legal...

Good deal!

As a side note, you can drop this piece of code. It just adds unnecessary overhead because that declaration is implied by SQL Server, notice how it is not...

Not all characters are valid in XML. Your code looks fine. You have some bad data in the mix that you'll need to cleanse...either that or escape it before casting...

I was just helping someone on [what I thought was] an unrelated issue last week and their issue turned out to be the OLE DB data source 😀

http://www.sqlservercentral.com/Forums/Topic1073400-148-1.aspx

TEST! TEST! TEST! ...I should not have taken Bart's word on collations for granted! Thanks J. Drew. Why did you stop blogging?

alexander.kaltenbrunner, you can do as J. Drew suggested and...

This site is specific to SQL Server. Not that you won't get help here, but you may have more luck in one of the Windows Development forums where you'll have...

Using a binary collation was my initial thought. I suspect that adding the check for datalength will be slower than using the collation method but have not tested out that...

The max memory guidelines in the article should still be valid for 32-bit. The /3GB switch will add 1GB to directly addressable memory for SQL Server to get into which...

Glenn Berry is a trusted source:

http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx

I ran into a similar issue using Linked Servers to reach a MySQL DB, but it was on SQL 2005. The issue traced back a driver issue where it was...

Look into using the Conditional Split Data Flow Transformation in your Data Flow task.

rs80 (3/17/2011)

---

Pretty cool stuff...

So I think what you're saying is that even though SSMS has the limitation of truncating the XML when showing the results in grid or text (what...

You need to provide the password when running the package from the command line.

From MSDN article "How To Run a Package" http://msdn.microsoft.com/en-us/library/ms138023.aspx:

If the package encryption level is EncryptSensitiveWithPassword or EncryptAllWithPassword,...