• 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.