Script Task to Configure FTP Connection

Question

Post reply

Script Task to Configure FTP Connection

Lynn Pettis

SSC Guru

Points: 442467
More actions
August 11, 2009 at 5:16 pm

#203706

I'm trying to modify a Script Task to programmatically populate the required fields for an FTP Connection. Unfortunately, I don't seem to be able to access the necessary properties, including ServerName, UserName, etc.
Any help in accomplishing this task is greatly appreciated. I haven't been able to find much in the books I have available to me at the moment.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Paul_J Hall of Fame Points: 3698 More actions · Answer 1

Do you mean these?

Computer name where SSIS package is currently running: My.Computer.Name

User name SSIS package is currently running as: My.User.Name

Jeff Moden SSC Guru Points: 1004635 More actions · Answer 2

Dang... I'm doing a whole lot with FTP right now. The thing is, I don't know how to help you because I'm doing it all through .bat files controlled by T-SQL. Sorry, Lynn.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

Actually, I may have figured it out. Took a lot of digging and guess work. Preliminary testing looks good, but it is late, and I really don't feel like attempting to deploy the SSIS package from my desktop at work while working over a VPN connection from home.

I will to some more testing in the morning, and if it works, I'll let you all know. I know I asked for help and I should post what I found, good forum etiquette and all, but it also looks like a proper write-up may be a good article for SSC as well.

You all decide which you'd prefer and see what all is said here in the morning.

Thanks again! 😉

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

An update, yes I solved my problem. Yes I will share it, but I intend to do so in an article that I will start writing and try to complete within a week or two. I feel this is something that others may benefit from and an article seems like the better solution in this case instead of a forum post.

It took me a little longer at work than I expected, but that was just due to minor issues I needed to clean up between my development system and the server where I deployed the SSIS package. There were some minor differences on where the 7-Zip program was located.