Viewing 15 posts - 6,886 through 6,900 (of 7,168 total)
I would like to help...please post the DDL for your tables and some DML to create some sample data. Have a look at this article if you have doubts about...
March 18, 2011 at 11:15 am
Without seeing your file and all properties of your flat-file connection object it's hard to say, but I'll take a shot at it providing some background info:
SSIS does not support...
March 18, 2011 at 10:01 am
I would like to help but am having a tough time picturing what the XML looks like that models what you have on your side since I can't see your...
March 18, 2011 at 9:34 am
See if this post helps: http://www.sqlservercentral.com/Forums/Topic341391-149-1.aspx
March 18, 2011 at 9:02 am
tommyh (3/18/2011)
I was hoping that SQL would fail on the last comma in the create table part. But SQL was just as happy to create a table like that./T
I...
March 18, 2011 at 8:58 am
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...
March 17, 2011 at 9:03 pm
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...
March 17, 2011 at 4:12 pm
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...
March 17, 2011 at 4:05 pm
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
March 17, 2011 at 3:36 pm
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...
March 17, 2011 at 3:15 pm
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...
March 17, 2011 at 2:09 pm
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...
March 17, 2011 at 1:59 pm
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...
March 17, 2011 at 12:53 pm
Viewing 15 posts - 6,886 through 6,900 (of 7,168 total)