none
How do convert the Multiple Tables to Single Excel file with multiple sheet(for Each table) by Single Data Flow ?

    Question

  • 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

    Thursday, July 11, 2013 7:45 AM

Answers

  • 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. 


    Regards,
    Karthik

    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    Thursday, July 11, 2013 10:06 AM

All replies

  • 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 goal?


    MCSE SQL Server 2012 - Please mark posts as answered where appropriate.


    Thursday, July 11, 2013 7:48 AM
  • To avoid the conflict in my Total Package.

    So please provide the Dynamically with  For Each loop.

    Thursday, July 11, 2013 8:41 AM
  • 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


    Rajkumar

    Thursday, July 11, 2013 8:44 AM
  • Yes, Already I watched it,

    Configuring like below picture.

    Here Problem of dynamically creating the sheet ?

    Can help me ?

    Thursday, July 11, 2013 8:57 AM
  • What's the conflict? You really need to give more details. We do not have a crystal ball to look inside your packages.

    MCSE SQL Server 2012 - Please mark posts as answered where appropriate.

    Thursday, July 11, 2013 8:58 AM
  • What's the problem? What are you struggling with? If you don't tell us what is going on, we cannot help you.

    MCSE SQL Server 2012 - Please mark posts as answered where appropriate.

    Thursday, July 11, 2013 8:59 AM
  • 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.

    Thursday, July 11, 2013 9:44 AM
  • 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. 


    Regards,
    Karthik

    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    Thursday, July 11, 2013 10:06 AM
  • Thanks a lot  Karthik,

    I got IDEA by your link.

    Now I can  work on this logic & it should work.

    __Madhu

    Thursday, July 11, 2013 10:28 AM