As per Bob Geldof  - "Tell me why I don't like Mondays". Sorry, but could not resist that one.

Anyhow, just a guess, but you may want to check that nothing is...

Aplogies. To clarify:

 This script using SaveToStorageFile and SaveToStorageFileAs creates the scrip0t as binary format only. The same way you go to Package/saveas/structured storage file.

I want it in VB Script as if...

If you look at the code it is saved as a structured storage file.

".SaveToStorageFileAs .Name,strFilePath,"","""

I have looked at the dts object model documentation and there is no save as vb...

No ggod to me. I even commented on that post myself.

The main problem I have is being able to script them all out automatically in one piece of code either...

I do the exact same thing but instead of looking for the existence of a file I just import all the files in the directory looping through the files use...

One last throw of the dice for you. Check to see if the package that is failing is logging the execution result to the server in a different way to...

Unless your select statement is causing locks or running a mammoth sql statement, I don't see why it would slow down a web form.

All you are doing is a select...

It is very flaky trying to change the data pump task properties at runtime and very difficult to do, if at all.

To do what you want, you will have use...

Will. See if you can run a simple select statement from the other server in a scheduled package. If not, then its more likely a permission problem on the server...

Another thought. If you are trying to connect to a data source through a dsn or something similar, make sure this is still on the server as runing locally will...

Is it a text file you are importing.

Have the permissions changed on the file server where the source text file or whatever other source it is resides?

They do not disappear by themselves.

They have either been deleted through someone clicking on Clear All button

Or, I there is a setting at sql server agent level where you can define maximum...

The main difference to running a dts manually versus scheduled is the user account running the package.

I suspect that the user account for sql server agent account has lost previous priveleges that it had...

This will do it for you. But you will have to set a reference ot the cell in excel before calling.

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

Private Declare Sub mouse_event Lib "user32" (ByVal dwFlags As Long,...

If your calling it form various procedures, stick it in a functon.