Another problem with TDP 3.4 (3.4.0.2059): I have a .tas file saved from version 3.0 that I want to update. When I try to open it with 3.4 I get “You are opening a script that was created using a newer version of Automation…The script will not run in this version.”
I opened it in 3.2, it up-converted it and I was able to save that. I opened that in 3.3, it up-converted that and I was able to save that. But with 3.4, I get the same error with all 3 files.
This automation file runs several .sql queries to excel (Select to File).
Pursuing this further, I found that if I open the .tas file in notepad, and delete ClearWorksheet=“True” from this section, which shows up for one of the queries, I can then open it (and run it) in 3.4:
<ta1:SelectToExcelActivity x:Name="CAPP_Backlog_Summary" LinkFile="True" RowCountVar="RowCount_1" SqlScript="..\Backlog_Summary.sql" SqlScriptEmbed="" Description="Updates the data tab on the XLSX file, which has a pivot table to summarize. See: http://www.toadworld.com/Videos/tabid/831/TID/849/cid/154/Default.aspx" Suffix="" ExcelFileName="C:\_reports\Backlog_Summary.xlsx">
<ta1:SelectToExcelActivity.ExportInstanceOptions>
<ns0:ExcelExportInstanceOptions FileDirctory="C:\_reports" FileName="Backlog_Summary" **ClearWorksheet="True"** xmlns:ns0="clr-namespace:Quest.Toad.ImportExport;Assembly=ToadCore, Version=6.3.0.916, Culture=neutral, PublicKeyToken=c862883b2ae69822">
<ns0:ExcelExportInstanceOptions.FormatSettings>
<ns0:FormatSettings FormatType="ExcelFile" Row="1" QuoteChar="'" Column="1" Delimiter="," FileFilter="Excel (2007) Files (*.xlsx)|*.xlsx | Excel (*.xls)|*.xls" WorksheetName="DailyData" BlockInsertValue="500.0" FileExtension="xlsx" FolderImportDirectory="{x:Null}" ExcelAtLocation="{x:Null}" HeaderBackColor="LightGray" ExcelBeforeExportMacros="{x:Null}" ExcelAfterExportMacros="{x:Null}" />
</ns0:ExcelExportInstanceOptions.FormatSettings>
</ns0:ExcelExportInstanceOptions>
</ta1:SelectToExcelActivity.ExportInstanceOptions>
<ta1:SelectToExcelActivity.ConnectionDescription>
<ta1:ConnectionDescription Trl="oracle://IMCM/" Description="blabla" IsNullPassword="False" NodePath="Oracle\blabla" />
</ta1:SelectToExcelActivity.ConnectionDescription>
</ta1:SelectToExcelActivity>