.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

execute 64bit process

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :.NET Framework
 

I want to execute 64bit sidebar.exe from my code in windows7 but when I do it. It executes 32bit sidebar.exe.

 

How I can execute 64bit.




View Complete Post


More Related Resource Links

Execute Process task - On Error (i want to override the error message)

  
Hi, In my package I am calling one exe to copy the files from local folders to SFTP. I am using a execute process task and I am passing the parameters like (address, username, password,....). The exe and syntax are given below. SFTPCopier.exe <<machinename>> <<username>> <<password> <<local directory path>> The problem is when the exe is failing to copy the files to SFTP due to some reason, the SSIS package is outputting the entire command in the log information (including the username & password). I dont want to write the password in the log information. I want to remove that password from the log information when an error occured in the execute process task. Can some one please tell me the way to override the message? Can I put a on error handler for that execute process task and use a script task to modify the "ErrorDescription" variable? Will that works? Thanks in advance.  

Log Reader Error: The process could not execute 'sp_repldone/sp_replcounters'

  
I have transactional replication going between servers A and B. SQL Server 2005 64 bit A is Publisher B is Distributor and Subscriber Now I am getting the following Log reader Agent Error Msg The process could not execute 'sp_repldone/sp_replcounters' on 'A'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/MSSQL_REPL20011 Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed a log-related procedure, drop the connection over which the procedure was executed or execute sp_replflush over that connection before starting the Log Reader Agent or executing another log-related procedure. (Source: MSSQLServer, Error number: 18752) Get help: http://help/18752 The process could not set the last distributed transaction. (Source: MSSQL_REPL, Error number: MSSQL_REPL22017) Get help: http://help/MSSQL_REPL22017 The process could not execute 'sp_repldone/sp_replcounters' on 'A'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037) Get help: http://help/MSSQL_REPL22037 Can anybody help me in solving this issue? I read that we have to delete the existing publication and subscription.  Is there any way to solve this problem without deleting the existing subscription and publication Any help would be appreciated Thanks

SSIS Execute Process Task Give "Access is Denied" error but it is not related to access control.

  
Hello All - I have a very weired SSIS problem. I am using BIDS in two machines - Windows 7 Professional Edition x64 bit (development workstation) and Windows 2003 Standard Edition x32 bit SP2 (server) . The visual studio version on both the machines are Version 2.0.50727 SP2. I found that my package's ExecuteProcessTask fails with "Access is denied" error in Windows2003 but runs ok in Windows 7 dev box. I then tried to debug the package in the Windows 2003 environment itself. The package failed in debug mode too with the same message. After looking for a while I found that when I shorten the Argument length of the failing ExecuteProcessTask the task did seem to work. So in Windows2003 environment if my argument exceeds 1846 characters the ExecuteProcessTask fails with message "Access is Denied". If the argument string is less than 1846 it works ok. In Windows 7 environment there is no problem at all. It does not seem like access problem but I may be wrong. Has anyone seen this? I will appreciate any reply. Thanks, Niben  

SSIS Execute Process Task Problems

  
I have a command to decrypt a file that I can run from the command line and it works beautifully.  However, when I stuff it into an execute process task, it errors out every time or does nothing.   Here is the command I can run from the command line:   gpg -d --passphrase-fd 0 < c:\Dip_Fif.WUZ -o c:\Someoutputfile.in1  -r "KeyName" c:\Someinputfile.in1.pgp     I've pointed the execute process task object to the gpg.exe executable on my system and am stuffing the remainder in the arguments line.  I have also tried changing around all the timeout settings and sucess values.  I have found I can change the success value to 2 and it will show up as being green when complete, but the file doesn't decrypt.  It just in turn will throw an error on the next piece because the required file is not there.   I will probably end up writing a script to get this to work and use a script task but I really want to know why this will not work.   --Thanks--

Send multiple parameters SSIS execute process task

  

Hi,

We are using Execute Process Task in SSIS package to execute a batch file to house keep the generated flat files which are older than a week from the archive folder.

The same batch file is used to delete the some temp files generated in the process.

As the Archive folder and temp folder paths are configurable, we are trying to pass the folder paths as parameters to batch file.

I used Expressions tab of Execute process Task Editor to map the variable to Arguments property. This is working fine. but I need to pass one more variable as an Argument.

Can some one help me how to achieve this. Thanks in advance.

Regards,

Sreekanth ABS

 

 


Calling remote batch file using Execute Process Task

  

Hi,

The requiement is to create excel file. I cannot run this code using SSIS vbscript task because this requires Microsoft.Office.Interop DLL which can not be installed on the dev / prod server. Hence using the SQL task the data exported to excel.

But now the excel is required to be updated to merge some cells. The approach we are thinking is to keep VBS file with required code to UNC path. Keep the BAT file running VBS file using CSCRIPT command in same location. Call the BAT file from SSIS package using Execute Process Task. This approach is tested in local system and also works on dev server. But somehow the sample code used to create excel is not creating excel to UNC path.

VBS code below

Const xlSaveChanges = 1
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = False
objExcel.Workbooks.Add
objExcel.Cells(1, 1).Value ="Test value"
objExcel.ActiveWorkbook.SaveAs(\\server.com\folder$\Demo\Excelfile.xls)
objExcel.Quit

The BAT used to call above VBS file is given below

cscript \\server.com\folder$\Demo\Excelfile.vbs

The above UNC path is used in execute process task package which runs fine. But the file is not yet created.

Appreciat

Execute process on remote machine from windows service

  

Hi,

I am using Windows Management Instrumentation (WMI) to connect to a remote system. I am connecting to a remote system and executing an exe on the remote system. This works if it is a normal exe. I am passing the user name and the password as well.

But when I use the same code in a Windows Service, I get an error which says "Access is Denied." My requirement is to invoke the exe (every 2 hours) on client system from a windows service on the server.

My code looks like this:

Dim

 

processHandle As Integer
Dim connection

Execute process on remote machine from windows service

  

Hi,

I am using Windows Management Instrumentation (WMI) to connect to a remote system. I am connecting to a remote system and executing an exe on the remote system. This works if it is a normal exe. I am passing the user name and the password as well.

But when I use the same code in a Windows Service, I get an error which says "Access is Denied." My requirement is to invoke the exe (every 2 hours) on client system from a windows service on the server.

My code looks like this:

Dim

 

processHandle As Integer
Dim connection

SQL Server 2005 64bit -SP3 rollback process on A/P Cluster Environment

  

Hi all

Erlier I posted a questions Which I got Answer form Alberto Morillo & Siva...

See link http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/52bf813a-cd8b-4e40-a9a3-e80ceea0ee1b

in fact my question suppose to be  "SQL Server 2005 64bit -SP3 rollback process on A/P Cluster Environment"

Please some body guide rollBack process for given Rollout.

Pre-SQL Server SP3 Installation Steps. 

1. Prior to Installing the SP3,Take  the  Full Backup of All Database (System Databases, User Databases), Databases backup is required  for roll back process, If installation causes any Database Damages

2. Disconnect the all Application connects.

3. Announce the Down time for 60 minutes

SQL Server SP3 Installation Rollout Steps. 

1. Log into the server as an account that has privileges to install the service pack. On a failover
Cluster, this must be the cluster service account or a domain account that has ad-ministra

SSIS Package fails with Execute Process Task when run from SQL Agent Job

  

I have an SSIS 2008 package running on Win 2008 64-bit server. The package has an Execute Process Task that runs a net use command using cmd.exe to make a connection.

This runs successfully when tested from the command prompt and runs successfully when the package is run in Visual Studio 2008. However, when the package is called from a SQLAgent job the package fails with the error (actual servernames and passwords removed):

Failing Task Name = EPT Connect mapped drive Error Code = -1073573551 Error Detail = In Executing "C:\WINNT\system32\cmd.exe" "/C net use
\\servername\foldername /USER:userid password" at "", The process exit code was "1" while the expected was "0".

I have determined that a successfull connection should provide a exit code of 0.

The job runs under a proxy account but as explained when the package has run from within VS 2008 it was also tested to run under the proxy account and is successful.

It is not a 64-bit issue as I have tested it by running the package using the 32-bit version of dtexec.exe and the same problem occurs.

Also I have found that by running a simple command process within the Execute Process Task such as dir *.* it is successful when run from the job indicating that it is in fact something related to the net use command itself when run from

Execute Process Task

  

Hi,

Is the dynamic assignment of batchfile name in Execute Process task is possible.

For Example i have to assign the batch file name whenever the packages starts running but not hard coded. I have used the config file for the Destination manager connection which works fine, I just wanted to know is it possible to use .config file even for Execute Process task


Regards, Santhosh Hiriyanna

Execute Process Task For PING.EXE

  

Hi Gurus,,,

I have Created SSIS Package to check Server Status using Execute Process Task and Provided the below values

Executable: C:\WINDOWS\system32\ping.exe

ArgumentS:192.168.1.5

I wanted to send the output of  this command to Text file Hence created Variable "User::OutPutPath" and assigned to standardoutput  Variable.

However command output is not logging to output file. what could be the problem.

 

 


Malatesh Kakade

Passing Argument from Execute Process Task (SSIS) to a Batch File

  

Hi,

I have a batch process set up, which executes fine as long as the name of the file is built in.  My Execute Process task in SSIS also runs this batch file with succes.

I would like to pass the name of the file as a parameter from the Task (SSIS) to this batch file.  Looks like I am doing something wrong because it is failing.

This is the batch file:
C:
cd \Program Files\WS_FTP Pro\
wsftppro -s "local:D:\Folder1\Folder2\%1" -d HDMS:/To_HDMS/

---  The %1 is the parameter

The argument that I am passing in is in the 'StandardInputVariable'

Would really really appreciate some help!  Thanks so much!


Vicky

Issue with SQL 2008 replication logreader errors The process could not execute 'sp_repldone/sp_repl

  

I noticed the log reader agent with the following errors on a production server.

 

The process could not execute 'sp_repldone/sp_replcounters' on 'DB_SERVER'.
The process could not execute 'sp_repldone/sp_replcounters' on 'DB_SERVER'.
The specified LSN {00037507:00003d5a:0005} for repldone log scan occurs before the current start of replication in the log {00037690:000015b5:0004}.
The process could not set the last distributed transaction.
The specified LSN {00037507:00003d5a:0005} for repldone log scan occurs before the current start of replication in the log {00037690:000015b5:0004}.
The process could not set the last distributed transaction.
The process could not execute 'sp_repldone/sp_replcounters' on 'DB_SERVER'.
The process could not execute 'sp_repldone/sp_replcounters' on 'DB_SERVER'.
The process could not execute 'sp_repldone/sp_replcounters' on 'DB_SERVER'.
The process could not execute 'sp_repldone/sp_replcounters' on 'DB_SERVER'.
The specified LSN {00037507:00003d5a:0005} for repldone log scan occurs before the current start of replication in the log {00037690:000015b5:0004}.
I then tried to check the Msrepl_transactions table for any information. This was blank, before hand I had noticed a high number of deadlocking going on with the distribution history tables on thesame publisher/distributor.

I can't locate psexec.exe from "execute process" task when trying to set executable

  

I can't locate psexec.exe from "execute process" task when trying to set executable.

I click on the ... and Open dialog opens, I browse to C:\Windows\System32, where the psexec.exe is located, but, it doesn't shown in the files list.

When I open Windows explorer, I can see it, and execute it.

I'm running from VS 2008 on windows 7 64 bit.

Does anyone encountered such a problem? Any idea?

 

THNX

Jermy


Jermy

ASP.NET Architecture - ASP.NET Worker Process - HTTP Pipleline - Http Modules and Handlers

  
"ASP.NET is a powerful platform for building Web applications, that provides a tremendous amount of flexibility and power for building just about any kind of Web application. Most people are familiar only with the high level frameworks like WebForms and WebServices which sit at the very top level of the ASP.NET hierarchy. In this article I'll describe the lower level aspects of ASP.NET and explain how requests move from Web Server to the ASP.NET runtime and then through the ASP.NET Http Pipeline to process requests.

HttpContext.Items and Server.Transfer/Execute

  
The problem was basically that when a Server.Transfer call was applied the script container (and also various ClientScriptProxy script embedding routines) would potentially fail to load up the specified scripts.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend