Click here to Skip to main content
15,898,996 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi

I want to run the ssis package of the remote system through local machine.for this i created a bat file in the remote machine which is having ssis dtsx file .when the bat file is running on the remotes machine the package is getting executed .but when iam calling the bat file of the remote system which contains exection command of the remote package. Iam getting the following error.even though the bat file is called successfully. following the error iam getting


The AcquireConnection method call to the connection manager failed with error code 0xC0202009

even i set DelayValidation property to true but no use.

below is my code


ConnectionOptions connOptions = new ConnectionOptions();
connOptions.Username=@"adfasdfasdf";
connOptions.Password ="ddfd" ;
connOptions.Impersonation = ImpersonationLevel.Impersonate;
connOptions.EnablePrivileges = true;
ManagementPath myPath = new ManagementPath();
myPath.NamespacePath = @"root\CIMV2";
myPath.Server = "10.10.156.008"; // Machine name is IP address of machine e.q. "192.168.0.222"

ManagementScope manScope = new ManagementScope(myPath, connOptions);
manScope.Connect();
ObjectGetOptions objectGetOptions = new ObjectGetOptions();
ManagementPath managementPath = new ManagementPath("Win32_Process");
ManagementClass processClass = new ManagementClass(manScope, managementPath, objectGetOptions);
// //Get the object on which the method will be invoked
//ManagementClass processClass =new ManagementClass("Win32_Process");

// Get an input parameters object for this method
ManagementBaseObject inParams =
processClass.GetMethodParameters("Create");
inParams["CommandLine"] = sBatFile;
ManagementBaseObject outParams = processClass.InvokeMethod("Create", inParams, null);
Console.WriteLine("Creation of the process returned: " + outParams["returnValue"]);
Console.WriteLine("Process ID: " + outParams["processId"]);



kindly help in this regard
Posted

1 solution

seems to be x64 based JET /ACE OLEDB error...
Try /x86 setting in bat file to force 32 bit execution.

Thanks,

Kuthuparakkal
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900