APARNA (7/29/2009)

---

I have tried an empty string as well as passing null. I am not getting the expected results back, everything comes up as empty tags.

How to handle...

I have tried an empty string as well as passing null. I am not getting the expected results back, everything comes up as empty tags.

How to handle an overload...

For Anyone who would run into this situation. It was not the HTTPconnection Manager that was the issue but the WSDL file.

Their WSDL file had multiple virtual paths one...

Thanks a Ton. The case statement proved very useful and the CROSS APPLY as well.

You are right I do not have namespaces as "abc.com", "abcd.com" , "abcde.com"

They are...

As this is the first time I am working with XML with namespaces I am having a lot of issues parsing the data.

yet again I have run into problems with...

Thanks for your inputs. All these days I have used OPENXML without worrying about the performance implications.

Thank You for the response. This was a sample XML I will try with the actual XML and check how it works. In the meantime with your code snippet I...

Thanks for your response.

What are the advantages/disadvantages of CLR SPs as against the SSIS approach.AS I Am nt a .NET developer and purely a SQL developer it would be...

Othere SSIS packages running under the sql seerver agent user access the same folder, So I am not sure if that was causing this issue, as i do not have...

I am not sure at what point it hangs but I guess it is probably at the stage of unzipiing the files, I am doing some tests to rule out...

Sorry to be replying very late on this issue, thank you for your comments, As I had to quickly deliver the project I converted into a data set by pivoting...

I still seem to be failing to get the XML tags in readable format. Your help is much appreciated

Thank you that was useful.

When I query this against my database I get only 14997 from sys.columns, what If my empid is 15000? my seq generation fails in this scenario. Is there a...

create a table valued function for the sequence number and select from the sequence generator by doing aleft join

CREATE FUNCTION [dbo].[fSequenceGenerator]

(

@StartSequence INT,

@EndSequence INT

)

RETURNS @OutPutTable TABLE

(

SequenceNumber INT

)

AS

BEGIN

WHILE @StartSequence < = @EndSequence

BEGIN

INSERT...