Hi

I've got access to a web site link that creates a csv file for me to download.

ie http://100.1900.100.100/webmethods/WinScheduledTasks.aspx?t=1

I've tried adding a call to that link to my SSIS package before the FTP step as a script task

using

System.Diagnostics.Process.Start("http://100.1900.100.100/webmethods/WinScheduledTasks.aspx?t=1");


but the package completes before the download file has been made available and so fails as there is no file to download.

Any ideas on the best way to get this link to work in an SSIS package