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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy