I just got solution from this URL.... Hope this helps

http://codejotter.wordpress.com/2010/04/06/importing-multiple-text-files-using-ssis/

Lutz,

Its a great reply

You should write Xpath /xquery to extract data from the xml contained column and then insert into another table.

I am not sure what exactly you requirement is, but you can...

Now I am Using It.... Thanks

Thanks, But can you write a sample query lafter ooking at my query.

Thanks, But can you write a sample query lafter ooking at my query.

Okay Here is the sample data from the above XML should look like....

memberid accountno birthdate

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

REH000 ...

My purpose is to flatten the XML as table with rows and columns. In my sample xml above all the nodes "name" will be treated as columns and node "value"...

The XML I placed here is in a column of the table. Now when I have to shred this my result would look like this...

memberid ...

Thanks..... But the problem is i do not know how many rows are there in my table coulmn and I have to shred

Thanks a lot.... But could you plz let me know wht is cte "after with" and what is x.od.value i mean wht is x.od ?

Thanks a lot

The default port is al;ways 21, We do not use the port while ftping from command prompt.

Download FTP client to test your connection again, probably if you get the same...

Try to change the port because the default port is 21 and aslo try to test connection in active and passive mode.

SSIS Interview Questions

1. What does a control flow do?

2. Generically explain what happens inside a data flow task?

3. Explain what ETL is?

4. Which task would...