You may be able to use the HTTP Connection Manager - see this article:

http://www.sqlis.com/post/Downloading-a-file-over-HTTP-the-SSIS-way.aspx

or perhaps a Script Task that uses the .Net WebClient

Either approach will work. It would probably be easier to manually edit the config file.

Thanks - I'll set up some logging to see if I can catch something.

I think you would want to set the value of the process task arguments dynamically by using a package configuration. Is there a reason that these arguments need to...

Instead of hard coding the path to the XML config file, there is an option to store the path in a user-defined environment variable. This is available in the...

When you say you are using the "master" username to log in with Remote Desktop, is that the same account that the SQL Agent service uses when it starts up?

I Googled this link

http://bytes.com/topic/asp-net/answers/320433-load-web-page-via-windows-form-service

where he uses the System.Net.WebClient. Haven't tried it in an SSIS Script Task, but I suppose you could, as long as you import that library.

You could put a Derived Column transform ahead of your Data Conversion. Use a Conditional Expression to change the empty string to a zero. Since this value is...

Well, not having any knowledge of what your package does, or how it does it, I can only respond in a general fashion....

Scalability issues; is this due database growth? ...

An example of a UNC path to a remote server would be

\\server1\globaldrive\myfiles

if you had mapped a drive letter to \\server1\globaldrive\ it might be:

G:\myfiles

Your network administrators should be able to help...

By default, if you set up your package in a SQL Agent job, it will run in the context of the account that is configured with the SQL Agent windows...

I do not know why temp tables are not working for you. Maybe it's time you try the CTE approach? Then you wouldn't need a temp table -...

Sorry, I forgot about this -

You also have to set Delay Validation = TRUE on any tasks that use the temp table.

See this article re: temp tables in SSIS

http://consultingblogs.emc.com/jamiethomson/archive/2006/11/19/SSIS_3A00_-Using-temporary-tables.aspx

When you run the package in BIDS, it uses your windows account and permissions.

When you run the SQL Agent job, by default it runs in the context of the SQL...

I don't think you can reference a recordset variable from within a SQL Query - at least it's not something I have ever done. I think recordset variables are...