Recent content by RottPaws

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

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

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

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

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

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

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

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

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

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

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!!!

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

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

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

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!!!