XML : How to map the column like I want and how to avoid same same instance of the package accessing the same file?

I am learning SSIS and I have a question.

1)I have multiple xml file in a directory and I want to read them and validate and process and store it in a database.

What have I done is

  a)Use foreach Loop container to read file in a directory  b)use xml task(inside loop container) to validate the xml and store it in a variable  c)use data flow task inside the loop container and have used xml source to map the data.    

But my problem is it is selecting each element as a column.But I want to store whole xml data in one column and add some extra field also(like date created and primary ID).And I have no idea how to do it?

I don't know whether I should have created the separated question for this or not.

2)Before processing I would like to avoid two instances of same pacakge accessing the same file. How can I do this?

Thank you.

No comments:

Post a Comment