首页 新闻 搜索 专区 学院

powershelll 调用task ,task调用SSIS,SSIS包打不开

0
[待解决问题]

报错: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
}
'''

theDataDigger的主页 theDataDigger | 初学一级 | 园豆:6
提问于:2019-03-27 16:47
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册