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
Good morning. I need to send an e.mail reporting a problem with de Authorized Service Provider in Brasil. I contact Apple Brasil, but didn't solve. Someone know an Apple's USA e.mail i can use ? Thanks.There is a link at the bottom of this page. http [More]
Hi everyone, I am having some trouble setting up an analog start trigger for DAQ using an x series PCIe card (6351)... Attached is my configuration... After reading the manual (http://digital.ni.com/manuals.nsf/websearch/08B4B2E1B5373B94862579BA006E6 [More]
Hi,    I am using EXIT_SAPLKD01_001 where I need to populate 2 custom segments for idoc extension cremas05. I have created a function module separately where I have populated the 2 structures that is of same type as the segment structure. In the exit [More]
Apple says "online purchase for an iPhone 4s" it should say "Some may purchase an iPhone online" at the end of filling out the forms it informs me that I have to visit an Apple retail store -- not going to travel 150+ miles to get to a [More]
i have the colorchecker passport for some days. my workflow: import the .CR2 raw files from memorycard as DNG copy into lightroom. create a DNG camera profile with the colorchecker passport (LR export -> xrite colorchecker). then i choose the created [More]
I have bought an iphone 5 and signed up for icloud service to sync my imac. But minimum requirement for icloud is 10.7.5 and my imac is OS X10.6.8. Also the itunes version in my imac is old so cable sync with iphone 5 not working. I am not able to re [More]
I'm editing a podcast and need to use zero-crossing points to make inaudible edits. I have two vocal tracks, in sync, and want to be able to select zero-crossings in one and then ripple delete (e.g. to remove a word), applying that same edit to the o [More]
iCloud sounds promising BUT just to be safe, in addition to using iCloud can I continue to back-up via my computer & iTunes also? Thanks in advance... BobYes, you can sync contact and calendar information with iCloud if you're running Windows 7 or OS [More]
Hi there, I've been experiencing increasingly severe YouTube buffering times. Speed tests suggest I'm getting the 5mbps I should be, but according to YouTube's stats, my average rate over the last month was 2.39 mbps. Even that is heavily weighted by [More]
Hi, This is Udhayakumar, i have completed 1Z0-007-ENU: Introduction to Oracle9i: SQL alone. Now i would like to continue further level in this certification, so i need know the following clarifications: 1. What are the next levels after this to compl [More]