Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dataflow FTP task
Message
From
01/10/2011 04:29:47
 
 
General information
Forum:
Microsoft SQL Server
Category:
Business Intelligence
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01525246
Message ID:
01525332
Views:
43
>>Hi Sergey
>>
>>I eventually realised that :-)
>>
>>Any thought on how I could do it ?
>>
>>IS FTP Task does not support SSL/SFTP/SSH/TSL
>>>
>>>>
>>>>I want to add an FTP step to my dataflow package.
>>>>
>>>>I've added connection details that work in Filezilla but they don't connect in the FTP task step
>>>>
>>>>the message if I test the connection is
>>>>
>>>>Connection can not be established. Server name, port number, or credentials may be invalid.
>>>>
>>>>Is there anywhere I can find out more detail of what the actual problem is.
>>>>
>>>>The site uses port 9900 and Require implicit FTP over TLS.
>>>>
>>>> In the FTP task I can specify the port but not Require implicit FTP over TLS..
>>>>
>>>>Anyone got any ides ?
>>>>
>>>>Thanks
>>>>
>>>>Update
>>>>
>>>>Looks like this is a problem with the FTP task not supporting FTPS. Any suggestions on a way round this would be appreciated.
>
>Is using CLR integration an option ?
>The FTP handling would be simple in .NET

What do you mean by CLR (worried thats a ridiculous question)

I am wondering about a script task as the only other options seem to be an expensive bought package task or unsecuring the ftp step (thats not necessarily a problem but might depend on the holder of the ftp site )
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform