问题描述
我要通过ASP.NET code传递参数DTEXEC工具。我现在用的的Process.Start（）方法来触发SSIS包执行。
I have to pass parameters to DTEXEC utility through ASP.NET code. I am using the process.start() method to trigger the SSIS package execution.
dtexec /file C:\ssis\pkg1.dtsx
/conn "MyConnectionManager";"\"Data Source=localhost\TestSQL2008R2;Initial Catalog=ConnDB;Integrated Security=SSPI;\""
字符串2
/file C:\ssis\pkg1.dtsx
/conn "MyConnectionManager;Data Source=localhost\TestSQL2008R2;Initial Catalog=ConnDB;Integrated Security=SSPI;"
而通过手动dtexec实用工具执行包上面的命令行参数生成的。不过，我需要使用C＃通过这个命令行传递给的Process.Start（）方法ASP.NET。
The above command line arguments are generated while manually executing the package through DTEXEC utility. However, I need to pass through this command line to process.start() method in ASP.NET using C#.
我怎样才能重新present C＃字符串语句中，上面的命令行？换句话说，我如何通过使用 @ 字符躲避特殊字符，并通过有效的语句进程。开始（）？
How can I represent the above command line within C# string statement? In other words, how do I escape the special characters by making use of @ character and pass a valid statement to process.start()?
推荐答案
逐字字符串可能是最容易使用的硬编码这些字符串。
A verbatim string literal is probably easiest to use for hard coding such strings.
您只需要加倍每内心：
@"dtexec /file C:\ssis\pkg1.dtsx /conn ""MyConnectionManager"";""\""Data Source=localhost\TestSQL2008R2;Initial Catalog=ConnDB;Integrated Security=SSPI;\""""";
和
@"/file C:\ssis\pkg1.dtsx /conn ""MyConnectionManager;Data Source=localhost\TestSQL2008R2;Initial Catalog=ConnDB;Integrated Security=SSPI;""";
通过正规的字符串，则需要逃避每个和 \\ 原以 \\ 在他们面前。
With "regular" strings, you would need to escape each " and \ in the original with a \ before them.
这篇关于我如何通过DTEXEC实用程序命令行参数使用C＃语法的Process.Start？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！