SalesForce access key token generation in SSIS

[liana.melissa12]

Hi all, I am trying to pull SalesForce data into Sql server using MSBI ETL tools. I’m using script task for authenticating the SalesForce Access token. But the access token expires every 12 hrs and I’ve to manually generate a new access token and update into ETL before executing package. Is there any possibilities for a permanent access token key or any any way to generate access token key using refresh token key. Please help me on this issues.

Thanks.

[19dongibson81]

You need to look for information on salesforce crm customization. Everything should be described there. Maybe someone here has something to read?