That's fine, but when you have and next time you see the issue if you can post example of the details of the problem it will help us to better...

Gotcha, I will try to provide you the details when I get a chance.

Look at the Data Drive Query Task component in DTS, this is the best item for that scenario.

I think there is a lot of confusion here.

First you say

"in #temp1 there is a rfq with 7500 ptn"

And go on to say

"With this query should not appear that...

Again I need an example of the file layout detail. But as for selecting a destination you could use Active Scripting with FileSystemObjects to find all the files in a...

Can you provide and example of the file layout please. I am kinda confused on what you are actually doing.

First you state html file which cannot itself do any work to populate itself. Are you using IIS on the server and and ASP file or maybe COld FUsion on...

It will dynamically assign a port on the first start, it reuse from that point forward on subsequent starts. Now however if on a start some other application has taken...

Also what maintainence are you doing regularly on the database. And I believe Goce was refering to SQL Profiler in the comments previous.

Quite honestly the FTP object that comes with DTS in SQL 2000 is not very usefull. It would be better to do a batch file to do the processing and...

You will need to get the DB2 client install from IBM but I believe it should be on the DB2 media itself.

For this I have seen nothing that could do it all. I think ApexSQL had Proc Blster at one time but didn't get around to really using to see what...

Using IE and not seeing this on any of my machines even the PIII 550 with 128 MB of RAM I have right next to me at work.

Might try reinstalling...

Can you schedule the package and it fails or you cannot setup a schedule at all.

It is still up to the Query Optimizer which will use statistics to determine what indees to use. If the between object has the best index choice available it may...