Sitemap

Amicuk Programming Answers

Error while calling pscp.exe through a batch file which is called in SSIS Execute Process Task

2015-10-11   Views:9

Advertisement

Hi, I am using Windows Server 2012 R2 Standard, SSIS 2012. I am trying to copy files from a remote location by calling pscp.exe through a batch file (FileCopy.bat at location M:\bin\) which is referenced in a SSIS Execute Process Task. My batch file

Hi,
I am using Windows Server 2012 R2 Standard, SSIS 2012. I am trying to copy files from a remote location by calling pscp.exe through a batch file (FileCopy.bat at location M:\bin\) which is referenced in a SSIS Execute Process Task. My batch file content
is,
ECHO OFF
echo. >> M:\Prod\bin\SourceFile_FileLog.txt
echo %date% - %time% - Copy Start (XYZ_a201211155952avx0_69999.NOR.gz) >> M:\Prod\bin\SourceFile_FileLog.txt
M:\ProdFiles\bin\pscp.exe -unsafe -scp -pw aaaaa [email protected]:/ABC_data/*.NOR.gz M:\Prod\FromMediation\
echo %date% - %time% - Copy Complete >> M:\Prod\bin\SourceFile_FileLog.txt
The error I am getting is 
[Execute Process Task] Error: In Executing "M:\bin\FileCopy.bat" "" at "", The process exit code was "1" while the expected was "0".
Exactly same setup but using Windows Server 2003 R2 Enterprise and SSIS 2005, this works fine and copies the files successfully.
Please provide some guidance on this.
Thank you!
'In Persuit of Happiness' and ..... learning SQL.

The replay answer
Advertisement
Hi,
This is what I am getting while running the batch file from command prompt
M:\bin\mttrb1>CDR_FileCopy
M:\bin\mttrb1>ECHO OFF
The system cannot find the path specified.
The system cannot find the path specified.
scp: M:\Prod\FromMediation\: Cannot create file
scp: M:\Prod\FromMediation\: Cannot create file
scp: M:\Prod\FromMediation\: Cannot create file
The system cannot find the path specified.
'In Persuit of Happiness' and ..... learning SQL.

Go to See the other 3 answers

Error while calling pscp.exe through a batch file which is called in SSIS Execute Process Task

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am using Windows Server 2012 R2 Standard, SSIS 2012. I am trying to copy files from a remote location by calling pscp.exe through a batch file (FileCopy.bat at location M:\bin\) which is referenced in a SSIS Execute Process Task. My batch file[More]

Ssis execute process task error: process exit code was 1 while the expected was 0

Category:DefaultRelease time:2015-10-11Views:130

Hi Sir, in my SSIS Package(2012) i am using Execute Process Task which will call bat file.  bat file is located on UNC Path.i am having  the below script in the batch file.  del \\servername\foldername\name.txt  rcmd \\servername D:\name1.bat  del \\[More]

SSIS-Execute Process task Error in 2012 version _File/Process "\\Servername\Foldername\batfile.bat" is not in path

Category:DefaultRelease time:2015-10-11Views:130

Hi Sir, I have develop the SSIS Package in 2012 version and i am calling the SSIS Package using Stored Procedure according to my requirement and that stored procedure will be using in my SSRS report Datasource. once after the SSIS Pacakge has design[More]

NOT able to call exe in ssis execute process task

Category:DefaultRelease time:2015-10-11Views:130

I am creating an SSIS package in which we execute an exe file from the EXECUTE PROCESS COMPONENT which contains the logics and uses few sp's which checks the expiry dates of the certificates of some URL's. But when we keep the file on sever and run i[More]

SSIS execute process task error on unziping

Category:DefaultRelease time:2015-10-11Views:130

Hi I am using 7zip to unzip files in SSIS using execute process task. Here is the configuration of the task: executable: C:\Program Files\7-Zip\7z.exe arguments: e default-o\\servername\livechat\unzip\ However, on executing package in BIDS, following[More]

SSIS-Execute Process task Error _File/Process "\\Servername\Foldername\batfile.bat" is not in path

Category:DefaultRelease time:2015-10-11Views:130

Hi Sir, I have designed the SSIS Package in 2012 Version. and i have deployed into the Integration Server,using Project Deployment Model. In the SSIS Pacakge we are calling the batch file using Execute Process task. when i am Executing the SSIS pacak[More]

Pass Passord Variable to a Batch File using Execute Process Task

Category:DefaultRelease time:2015-10-11Views:130

I have an FTP batch file that I want to execute using Execute Process Task. The content of the ftp (ftpscript.cmd) is as below: open ftpsite UserName Password ASCII get file  c:\temp\test.txt bye Using SSIS Execute process task, I was able to downloa[More]

Execute Process task Error

Category:DefaultRelease time:-0001-11-30Views:130

Hi All when i am using the Process execute task in ssis it is failing with the fallowing error [Execute Process Task] Error: In Executing "C:\Program Files\PuTTY\pscp.exe" "echo y | pscp -sftp -pw Password [email protected]:/opt/DSC_6_0_R5/[More]

Execute process task argument is not working for sph file and ogr2ogr.exe

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am trying to load shape file into a sql spatial table. A execution process task is used to run the ogr2ogr.exe program. This is how the process tab looks like . Executable : C:\gdal_ogr2ogr\bin\gdal\apps\ogr2ogr.exe Argument :  -f MSSQLSpat[More]

Execute Process Task error-Unzip Files

Category:DefaultRelease time:2015-10-11Views:130

Dear All,    I have a SSIS package, that downloads a Zip file from FTP Server and extract and load that information in Sql Server Table. In my case every time I have only one file in FTP Server. There is no possible to get multiple files from FTP Ser[More]

Execute Process Task Error - Powershell script

Category:DefaultRelease time:-0001-11-30Views:130

I've got a powershell script that is executed through a Execute Process Task that is giving me an error when executed through the Execute Package Utility on a 64bit server. "c:\windows\system32\windowspowershell\v1.0\powershell.exe" ""[More]

Hot
I have 2 MBAs (one for me and one for wife) and a TimeCapsule. I have data that I backed up on the TimeCapsule under the Data folder (mostly pictures) that would be nice to be accessible to both computers. On my MBA I can go into Finder and click on [More]
After filling out my complete acct info in iTunes Store in order to purchase an album that exceeds the amt of my credit from a gift card, I am prompted to check with the customer support for iTunes, and it will not simply charge my credit card that I [More]
Hi all, How can I mount an NFS that filename will appear as lower case? The NFS used stores filename in upper case while application porgram run on Sun Solaris only accept lowercase filename. now I'm getting trouble in upper/lower case file name. All [More]
I have two new classed, one extends Document (call it CustomDoc) and the other extends Folder (call it CustomFolder). Is there any way to use the iFS webui to create these instead of the standard Document and Folder objects?Do you want all iFS Files [More]
I am using Acrobat 9.0 Standard to sent documents for email review. However none of the recipients ever see the yellow banner with the "Send Comments" button or the "Comments & Markup" toolbar. I am using Outlook with Microsoft Exc [More]
It worked fine originally then started crashing. Safari does the same thing. Netflicks says it's a brouser issue.We're sorry to hear that your Firefox seems to be crashing when you open it. Please perform the following steps to give us a crash report [More]
Another person was able to connect, and my airport icon in the menubar said I was connected, but I wasn't able to access anything. Should I be concerned about a hardware issue? I just think it's strange that I couldn't connect, even though it said I [More]
Home Sharing could not be activated because an error occurred (5599).Me neither... But my home haring did just come back after signing in and out of iTunes and trying to turn on home sharing....judging by the popularity of this issue right now and th [More]
I just bought a Brother MFC-J4710DW multifunction printer but whenever I select Printer Options from the pop-up menu of the print dialogue box, the application I am printing from crashes leaving an error message saying the following (TextEdit is only [More]
Hi everyone, How do I set Thunderbird to be the default email program when emailing photos using Iphoto 6? Under preferences, it offers four choices (Mail, Microsoft Entourage, Encarta and something else.) How do add Thunderbird to this list - or at [More]