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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by RottPaws

  1. RottPaws

    SSIS -- ETL, then move Excel file

    I looked at trying an ADO connection, but the examples I found seem to indicate that the format of all the sheets needs to be the same as it loops through the files and then a nested loop goes through the worksheets. The file I'm working with has a different data structure for each sheet. So I...
  2. RottPaws

    SSIS -- ETL, then move Excel file

    I'm using the ACE driver. Provider=Microsoft.ACE.OLEDB.12.0; I've never used an OLEDB or ADO.NET connection with an Excel file. I'll look in to that. I put the data flow tasks in a sequence container, but it didn't make any difference. When it comes out of the sequence container, the file...
  3. RottPaws

    SSIS -- ETL, then move Excel file

    It's one Excel file with multiple tabs. The data flow tasks are all set up with constraints so they run in sequence and the last one leads to the file system task on success. I'll try the Sequence Container and see if that makes a difference. Thanks! _________ RottPaws If you don't report...
  4. RottPaws

    SSIS -- ETL, then move Excel file

    I've got an SSIS package that is supposed to loop through the tabs of an xlsx file, extract data, and then move that file to an archive folder. It sounds simple enough, but I can't it to work. I have a Foreach Loop container that gets a collection from a network drive and gives the file name...
  5. RottPaws

    Save user data lookup field values

    I've inherited an OpenOffice template that has user data look-up fields for work phone number and fax number. There is a macro that does some manipulation of the document and then saves it as a .sxw file on a network drive to be imported by a document imaging system. oDocument = ThisComponent...
  6. RottPaws

    MSSQL 2005 Express reinstall sa password error

    MS SQL Server 2005 Express was installed on our SBS server as part of TimeClock Plus 4.2 that was not working. Both were having problems, so I removed them through the Control Panel Add/Remove Software tool. I'm trying to reinstall, but when the SQL Server 2005 Express installation gets to...
  7. RottPaws

    Regexp help -- matching filenames with different versions

    Excellent! Thank you so much!!! _________ RottPaws If you don't report a problem, I probably won't fix it.
  8. RottPaws

    Regexp help -- matching filenames with different versions

    I'm trying to loop through a group of files for processing, but some files may have different versions in the batch and I only need to process the latest version of each one. I've got an array of filenames (reverse sort): @stl_files = [ 'STL-20120925.01.006_IPSP.CSV'...
  9. RottPaws

    Remote Desktop domain/certificate problem

    The self-issued certificate worked fine once it was downloaded to the local machine. After hours of frustration and research, I finally figured out the actual problem I was having was I needed to ad an A Record to the DNS server for the remote sub-domain. Once that was done and it had time to...
  10. RottPaws

    Remote Desktop domain/certificate problem

    We've got SBS2011 Standard installed and we're having difficulty with the remote desktop feature. I've been tasked with figuring it out. I've either been on google or had my nose in a book for a few days, but haven't been able to find any info that has been helpful. From within the domain. I...
  11. RottPaws

    replace last REGEX match

    I figured it out using the lookahead assertion. $order_list =~ s/(, )(?=\d+$)/, and /; _________ Rott Paws ...It's not a bug. It's an undocumented feature!!!
  12. RottPaws

    replace last REGEX match

    I have a string of comma delimited numbers and I want to replace the last comma with ' and '. I can write a regexp to find the last instance of ', ', but I haven't been able to figure out how to replace just that. It drops the last order number from the string $ord_list = '12345678, 23456789...
  13. RottPaws

    Automate web browsing

    Thanks for the info. I'll give it a try. _________ Rott Paws ...It's not a bug. It's an undocumented feature!!!
  14. RottPaws

    Automate web browsing

    I need to write a script to mine data from a web site. I could do it in Perl, but now I'm stuck on an environment that only has PHP and I'm a newbie in PHP. If anyone could point me to a tutorial or an example script for what I need, that would be great! Here's what I need the script to do...
  15. RottPaws

    Refresh/reload opener without retry pop-up

    Thank you! So simple! I can't believe I haven't seen that in any other thread on this topic. _________ Rott Paws ...It's not a bug. It's an undocumented feature!!!
See more

Part and Inventory Search

Back
Top