As with so many other things in the IT realm, the best answer to this question is... It Depends.

I have seen applications where the Web application spoke...

The basic Process for this woudl be to create a DTS task.  Create 2 connections, one usign you informix driver, the other with your SQL Server driver.  Then Highlight them...

I may be incorrect with this, but I thought that the only way it would do that would be to make sure that you have a share on your local...

Have you considered trying to use sp_MSforeachtable?  It's rather a bit like sp_MSforeachtable where it will loop through your tables running your command on each tablename.  sicne you have 4...

Can you give a bit more information on what you're trying to do?  We would be much better able to help in that case. 

Thanks.

-Luke.

Ideally, I'd want to not only have the setup somewhat like what has been stated above, but also think about splitting up the drives on different SCSI channels.  That way...

Now that I’ve reread your original post, my question is why do you need to do this in a loop?  Why couldn’t you just use something like this…

SELECT...

You're asking how to add another index?  The easiest way to do this for a newbie is via SQL Enterprise Manager.  Right Click on the proper table choose all tasks,...

This is something I beleive that could be done with Servers Alive.

http://www.woodstone.nu/salive/features.asp

the free versoin allows 10 checks and  can be used without a time limit, for $139 you get...

Can you tell us a bit more about your package?  Is it just a simple copy column transaction or are you doing more with the package?  Are you getting any...

Or for a bit more safety, and if your firewall supports this, set up a VPN to get the remote developer into your network and then only allow him access...

Couple of different ways to do this, depending on how you are going to executing your DTS job.

First what you need to do is create a global variable (GV) . ...

See these articles for more information....

http://www.sqlservercentral.com/columnists/RDyess/temptabl.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k

-Luke.

I also have to suggest the PIX 501.  It's only $419 from CDW (only around $270 more for unlimited users which you can upgrade to at any time, just have...

I know it would be rather difficult to manage, but I'd imagine you could do a lot of what you want via DTS.  You could take thier scripts and create...