Hi,

My requirement:

3 Tables ----> 3 sheets in 1 Excel

How do I dynamically in Single data flow in SSIS(For Each Loop container)?

Reporting Point of view So I need Single Task(without script Task).

Please Help me.

Thanks

--Madhu

You just add 3 different OLE DB sources and 3 diferent Excel Destinations.

I'm also still not sure why it has to be one task only. Does it matter in how many task the SSIS package accomplishes his

To avoid the conflict in my Total Package.

So please provide the Dynamically with  For Each loop.

Hi Madhu,

The below example loads data from multiple excel sheets to OLE DB destination. Do the exact oppsite for your case!

http://stackoverflow.com/questions/7411741/how-to-loop-through-excel-files-and-load-them-into-a-database-using-ssis-package

Yes, Already I watched it,

Configuring like below picture.

Here Problem of dynamically creating the sheet ?

Can help me ?

What's the conflict? You really need to give more details. We do not have a crystal ball to look inside your packages.

What's the problem? What are you struggling with? If you don't tell us what is going on, we cannot help you.

My Plan:

1. Generate 3 excel sheets by SQL task by giving Variables (V1: sql syntax :Create sheet ( .......))

but total Syntax is not accepting only Create sheet (

so How can create the value for V1 ?

hence How can I declare the variables with values for auto generate the sheets query?

2.Dynamically read the tables by data flow

3.Dynamically varying the above  generated excel sheets to transfer the OLEDB source  data.

Here is a link that has similar set of requirements i.e. based on certain criteria (in this case the User) the data from table is loaded into three separate excel sheets within same excel document. You can script your requirement in the similar fashion. In your case modify the source query to pass in data required for the sheet.

Also I do not see the use of limiting the DFT components.