Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Mrbaseball34

    Xpath quandry..

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

    Xpath quandry..

    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?
  3. Mrbaseball34

    Xpath quandry..

    Below is a snippet of one of my NAXML file. I am using XPath to parse the nodes, however, I am having difficulty getting this where it doesn't duplicate values. I need to prepend the XPAth query for FuelGradeID and FGMPositionSummary to get the correct nodes when iterating the FGMDetail...
  4. Mrbaseball34

    Wise Installation 9: Problem Killing Processes

    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...
  5. Mrbaseball34

    Wise 9.02: Updating Text file not working

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

    How to customise Unwise.exe welcome message

    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.
  7. Mrbaseball34

    Wise 9.02: Updating Text file not working

    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...
  8. Mrbaseball34

    WebBBS and CAPTCHA??

    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.
  9. Mrbaseball34

    Help with DTS Transformation Script

    Thought you might like to see the final script... I am importing directly into the ADMaxYield table now instead of going through the MaxYieldImport table. Function Main() Dim strVar Dim strLeft Dim strRight DTSDestination("ReinYear") = DTSSource("Col001")...
  10. Mrbaseball34

    Help with DTS Transformation Script

    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.
  11. Mrbaseball34

    Help with DTS Transformation Script

    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.
  12. Mrbaseball34

    Help with DTS Transformation Script

    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...
  13. Mrbaseball34

    Help with DTS Transformation Script

    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.
  14. Mrbaseball34

    Help with DTS Transformation Script

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

    DTS Transformation problem- Banging my head against the wall!!

    Look again...
  16. Mrbaseball34

    Help with DTS Transformation Script

    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...
  17. Mrbaseball34

    DTS Transformation problem- Banging my head against the wall!!

    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.
  18. Mrbaseball34

    DTS Transformation problem- Banging my head against the wall!!

    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...
  19. Mrbaseball34

    Help with DTS Transformation Script

    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...
  20. Mrbaseball34

    Help with DTS Transformation Script

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

Part and Inventory Search

Back
Top