Post reply

script task and excel format syntax

  • September 14, 2022 at 3:44 pm

    #4087680

    Hello, I'm a newbie to script tasks and require some assistance.

    When using SSIS/script task, I have the following code which creates excel files in xls format.

    However, I would like to create them in xlsx format - what do I need to change in the code.

    Thank you.

     

    Public Sub Main()
    Dim url, destination As String


    destination = Dts.Variables("varDestinationPath").Value.ToString + "\" + Dts.Variables("varRSParameter").Value.ToString + "_summary" + ".xls"
    url = "http://xxxxxx/ReportServer?SummaryInvoice&rs:Command=Render&invoiceNo=" + Dts.Variables("varRSParameter").Value.ToString + "&rs:Format=EXCEL"

    SaveFile(url, destination)

    Dts.TaskResult = ScriptResults.Success

    End Sub

  • September 15, 2022 at 4:10 pm

    #4088187

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • September 29, 2022 at 10:15 am

    This was removed by the editor as SPAM

  • October 20, 2022 at 3:38 pm

    #4102065

    The answer is to update the format to

    Format=EXCELOPENXML

    and then works

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

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