script task and excel format syntax

  • 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
  • Thanks for posting your issue and hopefully someone will answer soon.

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

  • This was removed by the editor as SPAM

  • The answer is to update the format to


    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