报错:Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: Failed to open package
file "??E:\tmp_lgt\BeiJing_Dev\Solutions\GS.FrameWork\InvestSuite.SSIS\InvestSuite.SSIS\InvestSuite_CorrAnalyOutput.dtsx" due to error 0x8007007B "The filename, directory name, or volume label syntax is
incorrect.". This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name when calling
LoadPackage or the specified XML file has an incorrect format.
首先SSIS包单独执行,可以导入导出数据
下面是Task:
'''
<Action ActionCode="DataReady" ActionDisplayName="数据导出" FunctionName="RunSSIS" SequenceNo="1">
<Parameter Name="SSISPackagePath" SessionParameterName="" Value="E:\tmp_lgt\BeiJing_Dev\Solutions\GS.FrameWork\InvestSuite.SSIS\InvestSuite.SSIS\InvestSuite_CorrAnalyOutput.dtsx" DataType="String" Usage="Task" />
<Parameter Name="SourceFilePath" SessionParameterName="SourceFilePath" Value="" DataType="String" Usage="SSISPackageVariable" />
</Action>
'''
'''
Powershell调用:
$AppDomain="Task"
$TaskType="Task"
$TaskCode="BenchmarkRates_CorrelationAnalysis"
$SessionVariables="{'Name':'name','Value':'','DataType':'String','IsConstant':0,'IsKey':0,'KeyIndex':0}"
$result=E:\Client\TaskProcessClient.exe $TaskCode $AppDomain $TaskType $SessionVariables
if(!("$result".Endswith("[Completed]."))){
throw $result
}
'''