I tried to use Process.start...but it doesn't execute the package at all ...not sure whether the code that I wrote is correct..
below is the code that I write for the Process.start:
Dim param As String
Dim arg As String
Dim packagePwd As String
Dim StartInfo As New ProcessStartInfo
packagePwd = "xxx"
param = "/set \package.Variables[A].Value;'\'" + a + _
"\'' /set \package.Variables.Value;'\'" + b + _
"\'' /set \package.Variables[C].Value;'\'" + c + _
"\'' /set \package.Variables[D].Value;'\'" + d + _
"\'' /set \package.Variables[E].Value;'\'" + e + _
"\'' /set \package.Variables[F].Value;'\'" + f + _
"\'' /set \package.Variables[G].Value;'\'" + g + _
"\'' /set \package.Variables[H].Value;'\'" + h + _
"\'' /set \package.Variables.Value;'\'" + i + _
"\'' /set \package.Variables[J].Value;'\'" + Convert.ToString(j) + _
"\'' /set \package.Variables[K].Value;'\'" + Convert.ToString(k) + "\''"
arg = "/f " + packagePath + " /de " + packagePwd + " " + param
StartInfo.FileName = "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe"
StartInfo.Arguments = arg
Process.Start(StartInfo)
The part that I'm not really sure is the parameter part, I'm not sure whether I put the quotes correctly and well, I just follow the example that I found from the internet.
please do let me know if you found it wrong.
Thanks.