Do you think SSIS can't or you can't?

If you use a loop, use substring in the constraint expression to extract the portion of the string you want.

You can now execute...

You could setup the modem to dial on demand. When the ftp task runs, it'll connect. It will probably cause lots of false connections though when other software tries to...

No.

That is why you execute queries in a transaction. Either Everything or Nothing. ACID.

You _could_ do it via a script component but that would be very very slow.

If you trying to modify the lookup at runtime, you cannot. Query for the lookup is static.

A quick google reveals..... http://msdn.microsoft.com/en-us/library/ms141704.aspx

You can't.

Use precedence constraints to control the flow of the package.

You can do it in a variable or in the script. If you adding the footer in the script, I would do it in there. No point in pushing the...

Saving packages to MSDB creates far more hassle than it's worth.

Editing, deploying, debugging etc etc.

Keeping them on disk is far simplier. You can keep packages, logs, config files all together.

I...

Your thinking is correct but you have to work with the 0's as strings and not ints.

0000000 + 1056 = 1056.

"0000000" + CSTR(1056) = "0000001056"

Create a disk resource and save the packages there.

The SSIS package can be executed from anywhere where the service can read them. i.e. A drive, San disk, online storage, SUB...

Unless it fails 6 times 😉

Without going to deep, having the CD does not mean you have the licences.

Find out from whoever deals with licencing.

Technically though, install developer edition.

But you have 2008 installed. Use...

It depends on what licence you bought. You did buy a licence didn't you?

Dev is a connection limited version of ent.

You cannot install ssis without 2005. If you had installed SQL 2008, just install the SSIS components.

Can easily be done with a dataflow task, XML Source and a OLE DB Destination.

It's pretty straight forward. See http://www.sqlis.com or http://blogs.conchango.com/jamiethomson/ for some tutorials.