Script Task to Configure FTP Connection
-
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.
-
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
-
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) -
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!
-
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply