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
We have a loader application coded in perl/c which connects to DB to load data from flat files. Whenever we have multiple such loader programs running, the listener dies and loading stops. The listener.log is around 2GB. I opened the loag and got fol [More]
Hello, I am stuck up with a problem, can anyone please tell me how do i pass a value from a JSP page to a JApplet, and the parameter passed through JSP should be displaed in the JTextArea. It would be kindful if any of you could help. Thanks Sanamhel [More]
Hi Friends.. I have created script to copy folder from one location to another location in PS. using Robocopy.. but By this script cannot copy the owner of the source location folder to destination..  below is the script.. please help me to add some [More]
iPad Mini 2 - iOS 8.1.3 When I've opened iTunes U for the first time it started to synchronise some courses. Some of them are old courses that probably I subscribed from my Mac in the past and that are no more present in my Mac. I've tried to sync iT [More]
We're going to Las Vegas during spring break. My daughter will be bringing her Mac Book Pro and I'll be bringing a G4 iBook. Any tips on going through security like while they ask us to turn it on? I've heard warnings about making sure that we make s [More]
Hi all,            Can u please explain hoe to convert business system into xml format. Thanks in advance NaveenHey you dont convert business system name in XML format, do you want to use ur business system name in message mapping?if yes,then use the [More]
I set up a test Webtools site based on OEC Computers backend db and created a WT user linked to Account C41000. When logged in using this user I see that there are three transactions dated in 2005 on that account which did not come accross to WT in t [More]
I recently installed Lightroom 2.6.  In my folders menu on the left of the screen, I can see all my folders, and when I select one, thumbnails of the pictures in it appear as they should.  However, if I select "all photographs" I get a "no [More]
I am new to LiveCycle. I want to set up a form where if a person hits a button or check box, it fills in the form with predetermined variables. I want to there to be several different buttons/check boxes which if selected fill out the form with the p [More]
Hi I'm compiled osmf 1.5 player - OSMFPlayer project for http streaming, using chromeLlibrary and OSMF.swc. I generated OSMFPlayer.swf without any errors, but when I'm trying to use this file I get a lot of errors with the player VerifyError: Error # [More]