Downloading files from MVS(Mainframe) to local folder using FTP Task(SSIS)
-
Hi,
I want to download the files from MVS system to my local folder using FTPTask of SSIS.
When I am using FTP Task of SSIS. I set the following
1. FTPConnection (did successful by credentials)
2. In File Transfer option, i need to provide the Remote Path Parameter. Here i am not getting(not seeing) the required files to download
But when i use through cmd prompt. it allows to me see the files in that location.
How should i mentioned in the Remote Path parameter to see the files.
Please help me out.
-
You are not going to see files, when you open the browser window. It is only used for browsing remote folders. If you want to download all files from specific folder you have to use:
/YourRemoteFolder
which is equivalent to:
/YourRemoteFolder/*
If you want to download files with specific extension (txt) use:
/YourRemoteFolder/*.txt
If you want to download specific file use:
/YourRemoteFolder/YourRemoteFile.txt
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Thank you for replying.
Let me explain like this:
I opened cmd prompt. and typed the following to connect to the mvs
ftp>open mvs
given user id
given password
login successful.
ftp>dir
it shows me --no datasets found. but when tried with following
ftp> dir 'p04.xusr.g481ddw(0)'
it return me the file.
but when try to connect the same on SSIS -FTP task. i don't know how to mentioned in remote path parameter to retrieve the file.
Hope you got an idea right?
please let me know i willl explain you with screenshot
thank you.
-
What is p04.xusr.g481ddw(0) ? File or folder ?
Try the following remote parameter:
/p04.xusr.g481ddw(0)
or
p04.xusr.g481ddw(0)
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
I tried with that. I can't get it into that.
-
kendoln (3/7/2011)
I tried with that. I can't get it into that.What happens? Do you get an error or what?
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
TITLE: SSIS FTP Task
------------------------------
An error occurred in the requested FTP operation. Detailed error description: 200 Representation type is Ascii NonPrint
200 Port request OK.
550 No data sets found
.
-
kendoln (3/8/2011)
TITLE: SSIS FTP Task------------------------------
An error occurred in the requested FTP operation. Detailed error description: 200 Representation type is Ascii NonPrint
200 Port request OK.
550 No data sets found.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
Thank you for posting the discussion link. That link really helped me lot. I found the article before but i couldn't concentrated much on that. However when i am going through step by step, i got the solution and tried the same on my application. it works.
Thanks you for your help.
Nagaraju. K
-
kendoln (3/11/2011)
Thank you for posting the discussion link. That link really helped me lot. I found the article before but i couldn't concentrated much on that. However when i am going through step by step, i got the solution and tried the same on my application. it works.Thanks you for your help.
Nagaraju. K
Glad you could get it to work. I could never get my FTP to work, :crazy: I then decided that I would rather run a JCL job on the mainframe, FTP from the MF, and have SQL Server agent sit and listen for the FTP files. That worked for me. 🙂
-
Could you please share your solution in ssis SSC Veteran?
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply