Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dataflow FTP task
Message
De
01/10/2011 04:29:47
 
 
À
01/10/2011 03:48:11
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Business Intelligence
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01525246
Message ID:
01525332
Vues:
41
>>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 )
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform