Business Intelligence

• Topics

  Started by

  Posts

  Last post

• Cube Proecssing taking time due to Reference Dimension

  CUBE has 3 fact tables and dimensions , the Fact1 is act like a dimension for other two fact tables…

  syed.sherfudeen-707109

  3 replies

  14 years, 7 months ago

  By: syed.sherfudeen-707109

• SSIS package scheduled job with SQL Server Agent, Job runs successfully but doesn't copy any files it should

  Hi, I have a pretty simple SSIS package that uses a for each loop to look for files saved on a loca…

  jniggel

  14 replies

  14 years, 7 months ago

  By: jobrien9796-693522

• What is architectural difference between sql 2000,2005 and 2008?

  can any one give full idea on What is architectural difference between sql 2000,2005 and 2008?

  srikanth2msbi

  1 replies

  14 years, 7 months ago

  By: Koen Verbeeck

• Differential upload

  Hi I need a demo on the following.Pls help me out 1.Data validating and error logging using ssis…

  savitha_gopalakrishnan

  1 replies

  14 years, 7 months ago

  By: Koen Verbeeck

• please give a detail example of file watcher task in ssis

  please give a detail example of file watcher task in control flow task in ssis (seeting of properti…

  jyothi_siri2000

  1 replies

  14 years, 7 months ago

  By: Koen Verbeeck

• How to read SSIS packages using VBA

  Hi All, My requriment is like i have to read all the SSIS packages names which are placed on a serv…

  prasanna-750812

  1 replies

  14 years, 7 months ago

  By: Koen Verbeeck

• SQL 2005 BreakPoints

  Hi All, I am trying to set breakpoints on an Execute SQL Task which assigns a value to a variable b…

  paul.corujo

  1 replies

  14 years, 7 months ago

  By: paul.corujo

• Sort is different from SSAS Cube browser and SSRS

  I deployed a cube in SSAS using BIDS, and within BIDS I assigned my dimension attribute to be sorte…

  jsaldana

  4 replies

  14 years, 7 months ago

  By: doodlingdba

• Using BIDS 2008, export to flat file, can we give unique name for the file?

  I am using BIDS 2008 to export to flat file(CSV) it will be automatically exported at 11.00 am in t…

  wewe_halim

  2 replies

  14 years, 7 months ago

  By: Koen Verbeeck

• SSIS - Performance

  Hi, Please tell me, how to improve the SSIS Package perpormance.

  sridhar.yalamanchi

  9 replies

  14 years, 7 months ago

  By: AmolNaik

• ssis related question

  how to restrict file reading, while others performing some updates on same file? this is similar …

  srikanth2msbi

  2 replies

  14 years, 7 months ago

  By: mateusz b

• SSAS - members of a Role

  Hi All Is there a query which I can use to view the members of a role in SSAS? Like as we do on reg…

  dbadotraghu

  1 replies

  14 years, 7 months ago

  By: mateusz b

• BIDS download

  Hi, I am having sql server 2005 and I need visual studio for BIDS and SSIS. What should i downlo…

  Skybvi

  27 replies

  14 years, 7 months ago

  By: Ninja's_RGR'us

• SSIS Performance problem

  Hello all, I'm designing DW where one of dimensions has over 5M records right now and each year wil…

  gpitkis

  7 replies

  14 years, 7 months ago

  By: Koen Verbeeck

• Roll back with error records capturing

  Hi, Is it possible to achieve the rollback of the data which is modified in the database during a p…

  RSuman

  3 replies

  14 years, 7 months ago

  By: Koen Verbeeck