Search results for query: *

Thanks, I figured it out. there were other sections that needed the mods, too.

Yes, Round Rock, to be exact. How would I change the XPath to get the ones relative to the one being passed to the GetNodeList function?

...'//FuelGradeMovement'); for i_fgm := 0 to FuelGradeMovements.length - 1 do begin // Get list of details {****** GetNodeList and GetNodeValue functions defined below ******} FGMDetails := GetNodeList(FuelGradeMovements.item[i_fgm], '//FGMDetail'); // For each detail...

In their infinate wisdom, M$ has deemed that some processes are only allowed to be killed by users if they were not started by the SYSTEM account. We have several processes that may be started by SQLSERVERAGENT service and they are started using the SYSTEM account and we need to kill them...

Make sure you have "Make Backup File" checked in order to actually change the file.

From thread772-1166884 Entry msg7 in Unwise.xxx (where xxx is your lang ext) in the %_WISE_%\Language directory controls what is said there. The %s should be the same as APPTITLE but for some reason it isn't being modified correctly.

Got this script: item: Set Variable Variable=INAPPDIR Value='c:\temp' end item: Read/Update Text File Variable=LINE Pathname=c:\DBUpdate0008.sql Flags=00000001 end item: Set Variable Variable=LINE Value=Ucase$(LINE) Flags=00100000 end item: If/While Statement...

Has anyone implemented CAPTCHA on WebBBS? (http://awsd.com/scripts/webbbs/) If so, would you be willing to share your efforts with the community now that it is Open Source? I am in need of CAPTCHA to prevent spammers on my board but don't know Perl well enough to implement it myself.

...5))) strRight = Right(DTSSource("Col007"), 1) strVar = strLeft & strRight DTSDestination("HighYield") = FormatNumber(strVar * .1, 1, 0, 0, 0) strLeft = cStr(cLng(Left(DTSSource("Col008"), 8))) if (CLng(strLeft) = 99999999) then...

Wouldn't that be FormatNumber, instead? I found that it didn't work for me either... I don't know what I'm going to do without having to write an import program in Delphi, which is what I usually develop in.

OK, This is a temp table where the data is stored as strings. I then run another DTS to import into the real table where the data is numeric 5(9,2) I've tried doing it directly into the ADMaxYield Table and I couldn't get it to work there either.

DTSDestination("HighYield") = CStr(CSng(DTSSource("Col007"))/10) if (CLng(strVar) = 99999999) then DTSDestination("WarnYield") = NULL else DTSDestination("WarnYield") = CStr(CSng(DTSSource("Col008"))/100) end if...

I can't do Col007 like that due to it being only one decimal place. Should CSng(DTSSource("Col007"))/10 work? BTW, I wrote a VBA script and placed it in Excel and it worked perfectly with the EXACT SAME code as the DTS script. Of course I used cell values instead of column values.

Nope, look again.... ;-) 1 2 3 4 5 1234567890123456789012345678901234567890123456789012345 2001010011001997002000330000000825000000132000000013200 RRRRssCCCCccctttPPPhhhhhhWWWWWWWWWWmmmmmmmmmmOOOOOOOOOO FieldName From/To Length DTSColumn...

Look again...

You wouldn' t happen to be an Aggie, would you? <bg> I count TEN chars in the column. WarnYield : 26-35 pos 26 - 1 pos 27 - 2 pos 28 - 3 pos 29 - 4 pos 30 - 5 pos 31 - 6 pos 32 - 7 pos 33 - 8 pos 34 - 9 pos 35 - 10 MaxYield : 36-45 pos 36 - 1 pos 37 - 2 pos 38 - 3 pos 39 - 4 pos 40...

HUH??? The 1-7 numbers at the top were supposed to LINE UP with the 0's to look like this. They are not field numbers. 1 2 3 012345678901234567890 There ARE 13 columns in the data as well as the transformation. YES all starting pos and lengths are correct.

I'm trying to import the lines from a text file shown below into a table using DTS with a transformation script. ( fields in the file are not separated by '|', it is just for illustration ) 1 2 3 4 5 6 7...

I modified to this: Function Main() DTSDestination(&quot;ReinYear&quot;) = DTSSource(&quot;Col001&quot;) DTSDestination(&quot;StateCode&quot;) = DTSSource(&quot;Col002&quot;) DTSDestination(&quot;CropCode&quot;) = DTSSource(&quot;Col003&quot;) if Len(Trim(DTSSource(&quot;Col004&quot;))) > 0...

It is all continuous, sent to us by a government agency so we have no access to the format.