Run a ping and write to file while the package is running. It may or may not prove network issue but it certainly looks that way.

Also, I would not use...

You cannot change the metadata of SSIS at runtime.

Your only hope with this would be to either create lots of of data flows or build a package on the fly...

Nothing that I know of but should not be to much work. Try not use the system tables but rather sys.tables and sys.columns.

I would say your "having two instances open"...

Glad it's working...

Copying script tasks has it's issues. There is a nasty one where copy + paste and run, it runs code from the first one. I cannot remember the...

As mentioned, only the dtsx is important. However, backing on the sln file and others in the folder is a good idea because you don't have to recreate the solution....

Just a note: You cannot walk down your package from your script task. You need to create an instance of the package in the script task. Sucks a bit.

I have tried using the webservice task before and did actually find it rather flaky when talking to cold fusion. I ended up writing my own custom task to deal...

I don't use MSDB for storing packages so am shooting in the dark - does agent have access rights to MSDB?

What account is it running under, can you log on...

For the benefit of others, could you let us know what it was?

What makes you say the value has not changed? Do you add a watch window or using a script task, msgbox it?

If you have a variable you want to set...

I cannot recreate it. Everything as you have it, but for the source (I used script component) and the destination is correct.

Are your mappings for the destination correct?

What does profiler...

I suspect there is an error in the service.

The error is: There is an error in XML document (1, 3502230)..

Does this work with other apps? Can you call it through...

Hey, i've seen a "all fields are varchar, just in case" database.

What about the rest of the poor folk who were hoping to see the solution?

If you going to offer private help, do it via PM.

Why not do it in reverse?

Try this:

Update My Table

OUTPUT INTO #MyTempTable

Where

bla bla bla

Select * From #MyTempTable

You run the update, save the affected rows out to a temp table.

Dump the...