Recent content by rainbowrabbit

Thanks MDXer I will give it a go....

Thanks MDXer. I have had a look at attunity but do you have to pay extra to use as it looks like you can only download a trial version?

I am new to SSIS so here goes. I have managed to extract data from Oracle 10g (10.2.0.4) into a SQL Server 2008 database. I have transformed some of this data ok in SQL server bu I also need to load some of the summarised data back into Oracle and I can load some of this back into Oracle using...

It looks like we will never know what happened! I have looked at it this morning and the broken reports are all working fine??? Very strange....

Hi, We are experiencing some really strange behaviour from soem of our Crystal XI reports. When we browse the data in the fields it displays the information we would expect however if you create a formula with that field the result is blank (it's not null as we tested for that). The reports...

thanks for the info. We were hoping there would be a way of updating the existing schedules!!! It's is such a palaver to re-schedule reports in Enterprise as you have to start from scratch and we have around 150 to do :-<

We currently use Business Objects Infoview to schedule and email reports (Crystal reports) to different users on a daily basis. We have recently changed database servers and have updated all our reports to retrieve the data from the new database server. However, we have noticed that none of the...

Thanks for your comments, I think I will leave it looking like it is !!!

hi alex, I basically create some ADO recordsets and then loop through sticking data into appropriate tags. This an example below of how I put stuff in; This bit sets where I want to be (this gets very laborious when I am down to the 8th or 9th level!)... Set objRootElem =...

it looks ok in IE. I have just seen another tek-tips thread http://tek-tips.com/viewthread.cfm?qid=1372353&page=1 that basically sticks a textnode with a vbcrlf in after each element I add if I want it to look nice. I am not sure if I have the energy to go through all the elements and do...

I have written a vba routine in access that looks at a 3 of tables in an Oracle database and then puts all of that into an xml file. This works ok and the file works as I can upload it into the required website. However the actual file itself looks pretty ugly when not viewed through something...

thank you Remou it was the wildcards and yes I am using ADO!!

Hi, I can't see what I am doing wrong here I am concatenating an SQL string to replace apostrophe's from surnames so I can stick them in an xml file. I concatentate the query, strSQL = "" strSQL = strSQL & "SELECT tblEMSdata.CHILDIDENTIFIERVALUE, tblEMSdata.FAMILYNAME, tblEMSdata.GIVENNAME1...

Hi Remou, I have compacted and repaired to no avail. I have cut and paste the contents into word and it has a character count with spaces of 2200. I am beginning to think your suggestion of a separate table maybe the way I should go....

Hi, Access 2000 (9 SP3) Windows 2000 client I have a memo field in a table that contains descriptive text around requests for work being logged. This memo field gets updated when a user types in more descriptive text on the form. The descriptive text is appended to the orginal text with a...