Tuesday, March 27, 2012

FTP Task

I am trying to grab a file from an ftp server hosted on a mainframe. The path to the file is in the following format 'xxx.xxxx.xxxxx' Yes you read right there are single quotes surrounding a string. If I use the built in ftp program in command prompt I am able to download the file after executing the following commands.

ftp ftpserver.domain.com
userid
password
cd 'xxx.xxxxxx.xxxxxx'
get remotefile localfile

The problem is when I use an ftp task in a ssis package. When I define the remote path I get an error that says the path doesn't start with a /. Of course the path doesn't start with a / it starts with '. Just for giggles I added / infront of the ' and got an error that said the file doesn't exist.It is a known problem when using non-Microsoft FTP servers. You can search this forum for many conversations on that topic.

One workaround is to build your own batch file and then execute that batch file with an Execute Process task inside SSIS.|||

Phil Brammer wrote:

It is a known problem when using non-Microsoft FTP servers. You can search this forum for many conversations on that topic.

One workaround is to build your own batch file and then execute that batch file with an Execute Process task inside SSIS.

That's what I thought I would need to do. Just wanted to make sure the out of the box solution was really broke before I went down that path. Thanks!

|||

If you think that not being able to receive files from the stock FTP task on a mainframe is a serious bug and would like to see it fixed, please "vote" on the following:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=281893

sql

No comments:

Post a Comment