September 14, 2022 at 3:44 pm
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
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
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