Search results for query: *

OK, the server is loged in as SERVERADMIN acct, in the login users on SQL it has admin rights. The job fails with the following message ... The job failed. Unable to determine if the owner (PMSTAT\SERVERADMIN)of the job Test_GCR_2 has server access (reason: Could not obtain information about...

The job failed. The Job was invoked by User sa. The last step to run was step 1 (dts_Immunization_Update_3_29_04). NOTE: Failed to notify 'Glenn' via email.

The error is [298] SQLServer Error: 8198, Could not obtain information about Windows NT group/user 'PMSTAT\SERVERADMIN'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

I have a DTS Package that runs in the local packages section BUT doesn't run when I make it a job. I don't see anything in the log files, is their a way to do some detail troupleshooting of the error. It just indicates, 'job failed to run' ....

I have tried this and it returns a "Expected an end of statement" error. Is their anothe rapproach I should/could be looking at? HELP!!!

I did that BUT the file name became 'Filename.zip' How do I pass in a varible? Shell.Run "WZZIP C:\DATA\FTP\ARI\Filename C:\DATA\FTP\ARI\*.*"

...characters "mytestzipname" with a variable. Can/HOW do I do this? The following works just fine, making a zip file called mytestzipname.zip file. Set Shell = CreateObject("WScript.Shell") Shell.Run "WZZIP C:\DATA\FTP\ARI\mytestzipname.ZIP C:\DATA\FTP\ARI\*.*"

I did this and it worked .. now to format the datestamp ... using replace .. should be no problems .. FileObject.MoveFile "C:\DATA\FTP\ARI\*.*", "C:\DATA\FTP\ARI\ARCHIVE" Thanks for the help .... and more importantly the direction to look ...

receiving an error .. can't find file Set FileObject = CreateObject("Scripting.FileSystemObject") Set SourceFolder = FileObject.GetFolder("C:\DATA\FTP\ARI\") Set TargetFolder = FileObject.GetFolder("C:\DATA\FTP\ARI\ARCHIVE") Set FileCollection =...

I would like to get a list of the files in a directory and rename them. I can count the number of files, I have done it with a single file, but now I have 2 files and need to rename (append a date stamp)to them than copy them to another directory.

We are running 5.5. Anyone have any problems with large messages 25 - 30 MB locking the system? Where do I start looking .... ?

I want the script to check to see if the shared drive exist .. I can do that with a dive.isready BUT if it is not than I want to create a batch file with a one line command THAN run that batch file to connect. PROBLEM: it appears that the batch file is trying to run before it has a chance to...

When sending a mail message on a XP Box using the CDO.MESSAGE .... The following works, I don't understanf the use of the sch portion .... HOW can I set this without having to reference the schemas at the Microsoft site? Is it possible? sch =...

I want to to take a file with a date and time stamp attached to the file name, and rename it to file name and date. I won't know the name of the file because of the timestamp so I assume I need to have a wildcard of some type. Is their an easy way of doing this OR is it possible at all. The...

EEEKKKS ... I have this $Three is my input which is "Cell" regexp {([a-zA-Z]*)+$} $Three Check3 can I ? Do I set i [regexp {([a-zA-Z]*)+$} $Three Check3] to check if one of the items in the input is in the list? .. shouldn't return a 1 if it is ? So if my input is...

I have a string which should have only numbers (ie telephone number), I am currently stripping out and checking the length to determine if the number has an area code and returning it in the format needed. What I need to do is to look and if ANY are non numeric, send a null or 11111111111 or...

I want to open a file and get the line, break it into a list. This is my input file, want it broken into a list showing only the 6th element. RESULTS;305596;000577672;LMH;F;JEF;;;;;;;;;;"09/30/2003";0857;;;;;;;;;;;;;;;;;;;;;;;;;;;;-1;000577672; I can open a file ... an put the line...

Can I do a nested if staement in tcl? if {[string compare $LookForSTDRPTTEXT $Compare3] == 0} { set temp_1 [append temp_1 $inline] # Ok this is where if want to test it agin if it was true in the above statement - and WHERE do those {} go <grin> } else { set temp_1 ttt } puts...

Thanks - Both actiually work, it is nice to have a couple of examples, makes learning tcl much easier. I would be interested in your comments regarding best books, internet resources, comparison to AWK as a scripting tool, TclPro ....

I have found the problem, the txt file I am bringing in has a control character at the end of each line. In Wordpad it looks like a little square, I assume it is a carriage return or something. I debugged it and watched it as it went through. If i remove it from the original text file, it works...