Home Forums Data Warehousing Integration Services Copy excel sheet from an existing excel and paste in the same excel RE: Copy excel sheet from an existing excel and paste in the same excel

  • June 22, 2015 at 10:27 am

    #1807104

    Karthiart (6/21/2015)

    Hi All,

    I have an excel with 3 sheets. 3rd sheet contains pivot template. I want to copy that 3rd sheet and create 3 more sheets in the same excel using ssis. At the end, i will have the excel with 6 sheets.

    How to do this in SSIS? Please help me here.

    It sounds like you need a script task with VB or C# code.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]