Viewing 15 posts - 1 through 15 (of 20 total)
That worked a treat.....thanks !
Andy P
Andy P
July 2, 2003 at 8:31 am
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...
Andy P
June 12, 2003 at 5:17 pm
Thanks for that.....
That's the best way I've been called a muppet yet !
Seriously though......greatly appreciated.
Regards
Andy P
Andy P
June 10, 2003 at 8:22 am
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...
Andy P
June 10, 2003 at 8:13 am
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...
Andy P
June 9, 2003 at 1:18 am
Thanks for that.....I'll try and get this scheduled in asap.
Andy P
Andy P
June 9, 2003 at 1:13 am
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...
Andy P
June 6, 2003 at 9:20 am
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...
Andy P
June 6, 2003 at 7:18 am
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...
Andy P
August 13, 2002 at 7:46 am
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
Andy P
August 7, 2002 at 9:05 am
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...
Andy P
August 7, 2002 at 7:22 am
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...
Andy P
August 7, 2002 at 7:15 am
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...
Andy P
August 7, 2002 at 7:02 am
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...
Andy P
August 7, 2002 at 6:57 am
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...
Andy P
March 8, 2002 at 8:33 am
Viewing 15 posts - 1 through 15 (of 20 total)