Search results for query: *

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

I'm trying to refresh the parent window after a child window has finished some processing. Getting it to reload is simple enough. I've found thousands of threads with "opener.reload(true);" as the answer and it does work. But I'd like to make it work without the Retry/Cancel prompt on the...

What is the best/proper way to have one script run another and pass neede information to it? I have a cgi web page that can be used to request a report. Certain options can make it take a long time to generate the report and the web page will timeout and kill the script. So what I did is I...

I had tried that already and it was pulling the group members in the wrong order when it was supposed to be sorting them. I figured out a way to get what I need. When the numbers come from the database query, I convert them to 3-character strings with leading zeros if they are less than 100...

No. All that logical branch does is turn the text red if the member is "bad" on that particular snapshot. Even if I comment out the "foreach $this_hour (@hours) {" loop, the member numbers come up out of order. _________ Rott Paws ...It's not a bug. It's an undocumented feature!!!

It probably should be for convenience purposes of the people using the report. But I don't see how that would/should affect the sorting of the keys in the sub-hash. I added sort to that line also and it had no effect. I'm stumped. _________ Rott Paws ...It's not a bug. It's an...