Yes, Lowell is correct.  There are only a few options here.  Either the program HTTP.exe does not exist, or it cannot be found in your PATH.  If you do have...

What happens if you run the same command from a DOS prompt?

You cannot have a variable of any data type except type TABLE in a FROM clause in a DML statement.  A table variable is not a  variable that hold the table...

I'm a bit confused by your ActiveX script.  Did you say that you have a data pump task?  From your initial post, I was under the impression that you had...

If you need to dynamically popluate a destination column from another table, you need to use a lookup.  Have you tried this yet?

I guess I don't quite follow what you are saying.  Can you describe in more detail your multiple file scenario?

This should do it:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=342506

Yes, the browser comes in very handy and saves you from having to remember (and type) all of your object names. 

I the data pump, view the transformations.  Delete your existing transformations and create a new one.  You will be prompted for the type of transformation you would like to create,...

It may also help if you post the execution plans or at least tell us what the differences are. 

Have you tried to register the local SQL Server in EM?  If your Domain User account has been added as a local admin, I doubt it is a permissions issue...

SQL Server will more often than not use all of the memory available to it.  I can see on a system that is not very busy or where the requests...

With 16 GB, I woud give at least 14 GB to SQL Server.  I don't know if it is a rule of thumb or not, but I will usually give...

Use UNC paths and Windows security instead of mapped drives. 

I would suggest creating a numbers table and using a split function if you don't already have one.  Search this site for dbo.Split and you should find plenty of posts...