Search results for query: *

We are doing a large EAI migration project from SeeBeyond to BizTalk. Every day we are guessing methods implementations by reading Collaboration Rules written in JAVA - or peppering the only SYBND resource on the team in a hundred Emails and waiting on his answer, while he is tossed in many...

My package needs to be a High Performance (target: 150,000 rows in 30 minutes) ETL solution. We are using all MS technologies - SSIS, SQL 2005, BIDS, etc. I need to loop the recordset executed by a Stored Proc in a Execute SQL Task in a Source Script Component. If I use an ADO.NET Connection...

I have a Panasonic Cordless phone (KX-TC series). The number buttons on the handset have gotten very tight and dont depress well. I need to take apart the handset and repair this. I slid back the battery compartment and found 2 screws. But it doesnt seem to be enough, there are other screws I...

I have an EDI file Document 996 for Format version 3020 (which is not supported by the BASE EDI Adapter out of the box: ISA*00* *00* *01*043073964 *12*6082744330 *20051220*0604*U*00302*000003522*0*P*$ GS*CG*043073964*6082744330**0604*50006*X*003020 ST*996*500060001...

Oh... that is clever! I guess this works just as well.

This syntax works - DELETE RL FROM ReleaseLanguage AS RL WHERE NOT EXISTS ( SELECT * FROM VideoRelease As VR WHERE VR.MuzeId = RL.MuzeId AND VR.RelNum = RL.RelNum )

The Bitwise OR operator returns 22,840 rows SELECT * FROM ReleaseLanguage WHERE MuzeId | RelRnum NOT IN ( SELECT MuzeId | RelRnum FROM VideoRelease) whereas the checksum method returned 60,000 + rows This bitwise operator is basically the same route as the checksum isnt it? (possibly with...

Thanks for replying. I don't understand this syntax? When I run it I get these errors Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near '|'. Server: Msg 170, Level 15, State 1, Line 3 Line 3: Incorrect syntax near '|'.

I have 2 tables joined on a composite primary-foregin key relationship table VideoRelease MuzeId INT PRIMARY KEY RelNum SMALLINT PRIMARY KEY this is the Foreign Key for table ReleaseLanguage MuzeId INT PRIMARY KEY RelNum SMALLINT PRIMARY KEY LangID SMALLINT PRIMARY KEY I want to delete...

OK I figured this out via this hint http://searchwebservices.techtarget.com/tip/1,289483,sid26_gci879720,00.html Use an XSLT library called xmlchar http://www.xml.com/pub/a/2003/01/02/xmlchar.html and in the instance add this line (via pre-processing) (where xmlchar is the href to the...

I have a <Any> element in my Schema to catch any type of content - <xs:element minOccurs="0" maxOccurs="unbounded" name="MixedDescription"> <xs:complexType mixed="true"> <xs:sequence> <xs:any processContents="skip" /> </xs:sequence> </xs:complexType> </xs:element> But it does...