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