Wednesday, March 21, 2012

Script Task TimeOut

Anybody knows how to change the TimeOut of a Script Task?

Thanks!

What is timing out?

What exactly are you trying to do?

-Jamie

|||

The task call one asp page that makes some updates in a remote sql server.

If I call the asp page without SSIS the proces finish ok, but if I call the asp page with Script Task, the task returns a TimeOut error.

I need that the Script Task wait until the asp work finish.

|||

The script task doesn't have a timeout setting. I would expect that you could set a timeout in your calling code can you not?

Perhaps if you posted your code and the errors people would have a better chance of helping you.

-Jamie

|||

The code of the Script Task is:

Public Sub Main()
Dim myWebClient As WebClient
Dim remoteUri As String = "http://10.3.0.5/GOT/sap/get_articoli_definitivo.asp"

Try
myWebClient = New WebClient()
' Do the actual download
myWebClient.DownloadData(remoteUri)
Dts.TaskResult = Dts.Results.Success
Catch ex As Exception
' Error message we got back.
Dts.Events.FireError(0, String.Empty, ex.Message, String.Empty, 0)
Dts.TaskResult = Dts.Results.Failure
End Try
End Sub

|||

And the error message is?

I'm not saying I'll be able to help but anyone that might be able to help will need as much ifo as possible.

-Jamie

|||

A quick Google produced the following which may help:

http://www.dotnet247.com/247reference/msgs/58/291939.aspx

http://www.dotnet247.com/247reference/msgs/19/98610.aspx

http://www.codecomments.com/archive291-2004-3-160028.html

Did you try googling this yourself?

-Jamie

No comments:

Post a Comment