Copy excel sheet from an existing excel and paste in the same excel

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

    Regards,
    Karthik.
    SQL Developer.

  • Hi,

    Kindly suggest me a solution for this.

    Regards,
    Karthik.
    SQL Developer.

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply