Please any solution for this....

Hi, I'm new to SSIS. Working in Visual Studio 2008 environment. And I have a problem while working with XML source. I have an XML source file, we will get data to 20 tables when we extract the data from it. With the single XML source in data flow task, it is not possible to get all 20 tables data. I should not create 20 data flows to extract 20 tables data. Can anybody suggest me what I have to do to at this point?

So your single XML File contains schema and data that represents 20 different tables? It's been a while for me working with XML Sources. Can you have multiple outputs from one single XML Source? I think so. If so, create the one source and have it feed 20 different 'pipelines' going to the 20 tables.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Yes, You can have one source and multiple destinations. you can do that using multicast or conditional split transformation. For example : Source | <Data Flow Component> | Multicast Or Conditional Split (Depends on requirement) | ---------- ----------------------- | | OLEDB Destination(Table1) OLEDB Destinaiton (Table2)

You may also want to look at some script code from Simon Sabin to read XML files more flexibly. Talk to me now on

Hi, Thanks for you response. My source is XML not OLEDB.

Hi Todd, Thanks for you response. I am getting only one result set 20 different pipelines are not possible.

Check this link : http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/6503404d-58b2-4a96-a671-554aa9c1412f

You're in the wrong forum to be asking the question. I'll move this thread but please pay attention to posting in the appropriate forum if you're looking for quick answers.

Sean moved your thread - you did not need to repost it in the Integration Services forum - it was already there. I'm going to merge these threads. Talk to me now on

Raja, use multicast transformation after XML source,if the same data is to be loaded to 20 different tables. Your XML Source might return data in different groups. You can also redirect specific output set after the multicast transformation. Join all the output sets using a dummy key and then map the specific column from source to target. Join everything before you multicast the columns to differnt destinations.

Raja - I don't understand your comment. Have you tried the Multicast component? Can you describe your situation better? Provide examples? Talk to me now on

Hi Todd, Thank you. I have xml file data. Read the XML file --- call the Stored Procedure to insert the data into the tables. How can i do this using SSIS Package? Please any help... Thank You in advance...

Please try this, Keep You XML Source Add MultiCast Transform(this gives u Multiple Outputs:In ur case it is 20 Outputs) Add Conditional Split (apply ur filter condition here for every Target) for each Multicast Transform output Redirect the filtered rows to each TargetAdapter rajiv