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.
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"
Dts.TaskResult = ScriptResults.Success
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)