hi

Thanks for the reply. My concern here is to when i ope the xml file in IE web browser if i minimize the <safetyreport> tag the <sentdate> also should get...

Hi thanks for your immediate response.

Its 32 bit server with SQL server Enterprise Edition with SP2

Hi Gail,

I have followed the same steps and found that some stored procedures having highest duration abnd IO/CPU.

But my developer saying i can't further tune with query as this is...

yes exactly thats what i needed.!!

But i should be able to add multiple child nodes it.If could see my original post i have multiple child node and parent node are...

Dear Experts,

I am using this table and script to generate the xml output.

CREATE TABLE #tmp

(

messagetypeVARCHAR(50),

messageformatversionDECIMAL(5,1),

messageformatreleaseDECIMAL(5,1),

messagenumbVARCHAR(10),

messagesenderidentifierVARCHAR(50),

messagereceiveridentifierVARCHAR(50),

messagedateformatVARCHAR(50),

messagedateVARCHAR(50),

safetyreportversionINT,

safetyreportidVARCHAR(50),

sentdate varchar(10)

--...

)

GO

INSERT INTO #tmp

VALUES...

Hi,

I used a For each loop container and i followed all you mentioned step,but the dataflow task is inserting all the XML file records into destination table.

Please help me to...

Hi,

Should i use a File transfer task at the end to move the inserted file to another folder.

My initial requirement was in the common folder i will receive dially 1...

Hi,

My expression is giving an error can you please help me resolve this.

"C:\Documents and Settings\gangadharam\desktop\XMLSource\\"+ @[User::Datestring] +".xml

Error:

The string literal "C:\Documents and Settings\gangadharam\desktop\XMLSource\\"" contains an illegal escape sequence of "\D". The...

Hi David,Thanks for reply.

From where i can set EvaluateAsExpression property to true in the variable and pleas edo send me the expression as well..

as i am new to SSIS ..i...

HI,

I am not getting exactly how to convert this ls help me.

Thanks for your help..it helps me a lot..I will try this myself thank you very much for your guidance ..

Ok thank you very much for your help it helps a lot..Let me try this myself..Thanks for your guidance

Thank you very much its now working correctly..

One more thing if i execute the query in Query analyzer its returning the data.But After executing the package no rows are...

Thanks i made the correction and its working.

But the problem is again when i run the package i am getting this error

TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at Data...

Hi Thanks for reply as i am very new to SSIS can u pls help me.

I am getting below syntax error when i parsed the expression

I am using this expression...