System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel. (Error during tasks dataflow with Project as endpoint using SSIS))

English Forum Developers & API
1

Hey devs,

I am using a 3rd party SSIS add-on to create a dataflow task from Asana tasks to my SQL Database. I have selected task as my resource and Project as my endpoint, and entered my ProjectID.

image
image726×616 12.5 KB

However, when generating the preview or executing the data flow task, I am getting the error : System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel.

2
2731×619 12.3 KB

On the other hand, I was able to execute the dataflow for my projects
Thanks!

2

Hi,
I have similar case. Created on MS SQL SSIS package that connection to asana using PAT for auth ( https://app.asana.com/api/1.0/, Headers → “Authorization: Bearer " + “PAT”),
package sent get with parameters :
• portfolios/XXXXXXXXXXXXXX/itemsresource_type=project&limit=100&opt_fields=archived,color,created_at,current_status,custom_fields,default_view,due_on,due_date,followers,is_template,members,modified_at,name,notes,owner,permalink_url,public,resource_type,start_on,workspace,team,assignee • projects/XXXXXXXXX/tasks?opt_fields=permalink_url,name,assignee_status,resource_type,resource_subtype,start_on,due_on,due_at,completed,completed_at
In general package runs with status successful, but from time to time every day ( can be 5-9 times per day) I have seen next error: “The request was aborted: Could not create SSL/TLS secure channel”.
In case of job failed, job trying to run package again, (can be 4 times) after that job will complete with status successful. So it will be great to resolve this issue.
Thanks in advance.
Windows 2012 r2 str.
MS SQL server 2017 cu24.