Hi,

My colleague finally helped me with this. Problem was with web service connection wasn't closed. He asked me to use this

Soapclient.close().

This seemed to work.

Thank you!

Hi,

Thank you!!

My reference file also has array format and not generic collection format. I am not sure if I can use list when we have output as an array

Thank you 🙂

Hi,

OPENXML works fine if all have single parent node.

But I might want columns for different nodes. Do we have any option?

Thanks

thank you very much.. it is working for me now with "x"+ "c:\folder" +"-aoa" 🙂

thanks a lot for your replies :-).

I think for my condition, updating the field worked.

I declared a variable, and set the variable to (select max(date) from table) and then used...

Thank you very much for your replies.

Actually i wanted Case statement and then to update the columns .

Will try them.

Well there are around 5M data to process.

hey Thank you very much 🙂

I indeed followed this method only. I had source table and then wrote a Merge Stored procedure which updates/inserts destination table using Execute SQL task....

Hi,

Thank you all.

I got the solution from below link

http://mobile.databasejournal.com/features/mssql/managing-slowly-changing-dimension-with-slow-changing-transformation-in-ssis.html

My scenario was SCD type 2 described in the link.

thank you very much.. this indeed solved the error. I was trying with Casting as Date and that was throwing the error for me.

Hi Guys,

Thank you very much for your replies. I found below solution for my problem..

SELECT A.*

FROM YourTable A

JOIN (

SELECT CustomerID , MAX(Id) MaxId FROM YourTable GROUP BY CustomerID ) B

ON...

also,

another scenario is,

Scenario:

ODS table :

CustomerID column1column2column3

1abcabcabc

2xyz xyz xyz

Dbo table:

CustomerID column1column2column3 date

1abcabcabc 1/1/1900

2xyz xyz xyz 1/1/1900

Now If I get any new record for customerID "1" in ODS table, then...

Sorry for that.

Scenario:

ODS table :

CustomerID column1column2column3

1 abc abc ...

thank you :-).

how do I add an identifier back to ODS table? what does this mean?

Regards,

Chits