avoid time-out for Denodo ADO Net Source in SSIS
In SSIS, I was executing sql command in ADO Net Source of one of the Data Flow and was getting Time-out error after approximately 15 minutes. I used below clause after select statement.
context (‘querytimeout’ = ‘9000000’)
Here time is in milliseconds (in our case, ‘9000000’ is approx 2.5 hr).
For more info read “CONTEXT CLAUSE” in Denodo documentation in “Advanced VQL Guide”
Categories: Data Visualization, Denodo, SSIS
Data Visualization, Denodo, ssis
Comments (0)
Trackbacks (0)
Leave a comment
Trackback