I have been working on report creation in Business Object XI R2. The report i have created contains aggregated data(summary information) and deals with around 250 GB of database. The database is on SQL Server 2005 standard edition. I have to show summarized information from 2 years for more than 20 different criteria. The approach i am following is I am bringing the aggregated information in one DP and all different informations in other 4 DP. And i am using Synchrnization to link DP's to get the required groupings and present in different tab. I have successfully created the report and refreshing independent DP correctly. But the problem is when we are refreshing the complete report in one go. I am getting the error "There is not enough memeory to run this program. Please quit one or more programs, then press ok to try again." Is there any way around to improvise the performance of report and use less memory. Thanks in Advance

CodeManiac xxxxxxxxxx xxxxxxxxxx

Hi Abhijit, Thanks for quick reply. But on clicking the link "This may help you", it redirects me to some where else and I do not have any registration there. It would be great if you can post the solution here. Thanks :-D

CodeManiac xxxxxxxxxx xxxxxxxxxx

Hi, I am new to SSIS. I have two different servers, one is AS400 and other in SQL server. There is one table ABC on AS400 and two table ABC and XYZ in SQL server. I need to take the join of the tables ABC (of AS400) and XYZ of SQL server and need to push the matching records into ABC table of SQL server. Please advise me how can I achieve this in SSIS. Thanks in Advance.

CodeManiac xxxxxxxxxx xxxxxxxxxx

I have one script task. Withing this script task, I need to create and execute Execute SQL Task. Can be do so?

CodeManiac xxxxxxxxxx xxxxxxxxxx

Hi, I have created a dts package. all the values like Source Data connection, source userid and source pwd is passed through variables and for destination database all these values are hardcoded. At design time I used a DSN which points to SourceServer1. Using this DSN it stores mapping between source and destination at design time. After this I executed this pakage with the same DSN it worked perfectly but when I changed datasource of the destination from SourceSrver1 to SourceServer2, I am geeting error "SourceServer2 is not same as the SourceServer1". When I am passing all the connection info using global variables then why it is looking for the connection info that I provided at design time? It's very urgent, any help is deeply appretiated. Thanks in Advance.

CodeManiac xxxxxxxxxx xxxxxxxxxx

Hi, I have created 5 SSIS packages. All these are password protected. One of the packages is Driver package that calls Other packages based on some settings in the config file. Till now I was executing these packages using a job in SQL server. But now I want to execute packages from VB.net code. Please suggest how can I execute SSIS package from VB.NET. Any sample code would be very helpul. Thanks In Advance

CodeManiac xxxxxxxxxx xxxxxxxxxx

Hi, I am working on SSIS to perform following job. I am copying data from AS400. Now I want to modify the data So, for each record, if the claim number is 123456789..., change it to AAA456789... (you will overlay the first 3 characters). After this transformation, I need to push this data into SQL server. Please advise me how can I do this using SSIS. thanks in advance

CodeManiac xxxxxxxxxx xxxxxxxxxx

Hi Everyone, I have created one dtsx package in Sql Server Integration Services. Is there any way to assign revision number to my package? How can I update that revision number. :^)

CodeManiac xxxxxxxxxx xxxxxxxxxx

I mean the proces will happen every night for the data that changed during day time.

CodeManiac xxxxxxxxxx xxxxxxxxxx

Just one more thing that this process will happen in Batch.

CodeManiac xxxxxxxxxx xxxxxxxxxx

Sorry to confuse you. Let me explain you complete scenario. I am having two databases DB1 and DB2. DB1 has single table T1 and 15 columns namely C1, C2, C3 etc. DB2 has two table T1 and T2. T1 table is identical in both the databases. So T1 table has same 15 columns and same data in both the databases. T2 has 5 columns C1, C2, C3, C4,C5 which together constitute primary key. In T1 table of DB1 database, some of the records are modified. T2 table of database DB2 has the primary keys of all the modified records. I need to update table T1 of database DB2 for the modified records. I need a way to accomplish this. Hopefully I am clear now.

CodeManiac xxxxxxxxxx xxxxxxxxxx

Thanks for your reply. :-D :-D Can we do the same thing without taking join. I mean can we use IN clause for multiple columns?

CodeManiac xxxxxxxxxx xxxxxxxxxx

Hi Everyone, I am having one table which contains 5 columns. These five columns together contitute the primary key. I am having one more table which contains data for these primary key. I need to write a query which will bring the data from the second table for those primary keys which are available in first table. :doh: :doh: :doh: :doh:

CodeManiac xxxxxxxxxx xxxxxxxxxx