Problem with FTP Task in SSIS on SQL2005

Question

Problem with FTP Task in SSIS on SQL2005

Viewing 4 posts - 46 through 49 (of 49 total)

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

juan.maart SSC Rookie Points: 25 More actions · Answer 1

S.K. You are such a legend!!! I have been battling for 4 days to get the schedule to work. I have tried xml config files and the like and your SIMPLE solution was exactly what was needed. Thank you soooo much!!!

jamirphillips-790261 SSC Veteran Points: 208 More actions · Answer 2

Thanks a bunch. This worked like a charm.

Jamir Phillips

sahoong SSCrazy Points: 2545 More actions · Answer 3

i have created an ftp task and the connection works. i want to use the ftp task to move a data. the file is on my desktop. how can i point the ftp task to the file on my desktop for it to be transferred to the remote server.

thanks for your help

Lady SQL SSC Veteran Points: 271 More actions · Answer 4

This is what I did to solve the dilemma.

I created the configuration file on SQL Server. (exporting FTP Connection only so I didn't get too overloaded with rows)

When you create a configuration file in the project as SQL Server, it will create a table.

The table will have Password; the table passes the literal '*****' as seen in the project.

I put in the password

re-deployed and voila!

FINALLY it worked.