Couple of things to check,

OS and SQL service packs at same level.

Same MDAC on both machines.

Any other DB type application on the slow server? Something that could require older DLL...

quote:

---

Why not do a backup of your DEV and restore on TST and STG. This would be much faster then DTS and...

Try this

quote:

---

1.

CREATE PROCEDURE dbo.getModuleTitle

@ModuleID int OUTPUT

AS

blah...blah...

---

quote:

---

create...

No, you can run it from any sort of front-end the same you would any other stored procedure or SQL statement. You could set it up in a batch file,...

quote:

---

quote:

---

I generally put in some text that allows me to get past the assistants...

If you declare multiple variables you can use then in the EXEC statment like this,

EXEC (@sql1 + @sql2 + etc...)

Just make sure that the concatenated string makes a valid sql...

Actually I like Links the cat. I'd like it to be a bit more active though and hang around even when I'm not using an MS Office App.

And if I...

OK, is this a routine thing or one-off. What is the resulting table used for.

You can run a short VBScript that uses the filesystem object to iterate through a folder...

quote:

---

I blame the practice on Access database users. Access allows this practice and then if the Access database has to be...

add to this, avoiding the use of non-alphanumeric characters, wildcards, etc...

eg: tblName%

Arrrgghh!!!!

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Sounds like it may be a COM/DLL issue. Maybe try re-installing EM.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

A better option than providing a shortcut to execute the DTS package, would be to setup the pacakge as a scheduled job without a schedule. Then use sp_start_job to execute...

Do you need the contents of the files, or the filnames themselves? What "file" do you want to save the result to?

If you need to read the contents of multiple...

How are you importing the data in DTS, Bulk-Insert, Datapump??

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

quote:

---

quote:

---

We appear to have found the problem - in spite of the published information...