That worked a treat.....thanks !

Andy P

Not sure if this is your problem, but if your dts runs in isolation and it's only when scheduled that you receive the error......then the first thing I check is...

Thanks for that.....

That's the best way I've been called a muppet yet !

Seriously though......greatly appreciated.

Regards

Andy P

Appologies for delay.......exceptionally busy at the moment.......

I cannot find (quickly) a rename example.

The following example uses the global-variables to store the working names.

NOTE : The scripts are separate vb tasks...

I'll see what I can dig up....I know that most of my scripts that use the FSO are broken in 2 and exist either side of sql tasks. Plus they...

Thanks for that.....I'll try and get this scheduled in asap.

Andy P

I also do this I use the commands (in the relevant place) :

objFSO.CopyFile "src-Path\filename", destination-Path\filename",true

[where last boolean is for overwrite option]

and use the same folder

and then

objFSO.DeleteFile "Path\FileName"

to delete the original.

Hope...

I prefer to use a vbscript task to determine if a file exists !

Try this :

Option Explicit

Function Main()

Dim objFSO

set objFSO = createObject("Scripting.FileSystemObject")

If objFSO.FileExists("O:\MyFolder\MySubFolder\File.txt") Then

Main = DTSTaskExecResult_Success

Else

Main = DTSTaskExecResult_Failure

End If

Exit...

We don't have a problem with xp_sendmail (yet and touch wood). But the notifications are continuing to fail, even more are not getting sent now. The exhange settings possibility (from...

Thanks for that Brian.

I have passed that on to a colleague who can see if our operations guys can do this.

Regards

Andy P

Thanks for that Tim,

Checked the doc. But still no help there.

One of my jobs has an xp_sendmail call as one of the tasks, that always works, and even though the...

Slight ammendment to my last.

The sql 2000 boxes don't have exhange server on them yet so there won't be an issue there (YET?). It's just the 2 sql-svr 7.0 boxes...

We have a single mail account (sqlmail) and there are a whole heap of servers, I don't know if the 2000 boxes are affected but there are 2 sql-svr 7...

Check that you have a single mdf and a single ldf file. If you have multiple log files you may encounter difficulties with the re-attachment. (Worst case is you loose...

Thanks for all of this everybody.

I was aware that an upgrade to 2000 is recommended due to 'features' in 7.0 but, (again) it's down to politics of my client whether...