Business Intelligence

• Topics

  Started by

  Posts

  Last post

• Fixing Error: 2601

  Hi, I am getting this error when I am trying to update a column from a table which has a unique non…

  Trooper09

  1 replies

  11 years, 7 months ago

  By: antonyrampling

• Connection Manager - Assign Server Name during Runtime

  Hi All, I have a table where I have a list of sql servers in my network. I want to execute some sta…

  haichells

  1 replies

  11 years, 7 months ago

  By: Koen Verbeeck

• Dynamic Dimension Security in Analysis Services based on User and Datasource Dimension

  Hello I have an Question to Dynamic Dimension Security in AS. I have a following Problem. I want to…

  radik86

  3 replies

  11 years, 7 months ago

  By: MMartin1

• Command LIne DTS 2000 package import to SQL 2005?

  I have a SQL 2000 instance with 400 DTS packages; the databases for this instance are to be moved t…

  rainfollower

  3 replies

  11 years, 7 months ago

  By: WBCMMAN

• On Click "Calendar Control" Button, not showing Calendar Window In SSRS

  Hi, I am using Calendar Control for couple of Date type Parameters. When viewing report at Report M…

  Rachitha

  3 replies

  11 years, 7 months ago

  By: alex_2356

• 70-467 BI exam - how do I prepare for this?

  Hi Plan is to take the 70-467 bi solutions exam. But very disappointing to see that no official gui…

  Nasreenm

  9 replies

  11 years, 8 months ago

  By: b.fleming

• Can we enable or disable particualar "Execute SQL Task" ?

  Hi All I have created a package to track the log of SysSsisLog table into another table. I have use…

  nikku

  4 replies

  11 years, 8 months ago

  By: nikku

• The report server installation is not initialized.

  All: When i access the reporting Manager by http://localhost/report/, I get the above error message…

  YTZ

  3 replies

  11 years, 8 months ago

  By: gheno

• Data Driven Subscription for SSRS report using SSAS as backend

  I have a SSRS 2005 report that compares data between the two servers T36 and T38. The data is store…

  Nilesh-788004

  1 replies

  11 years, 8 months ago

  By: pahernandezgonzalez

• loading multiple file types into one table

  We have scenario where we want to load different types of files(csv, xls, txt) into one table using…

  Abhijit More

  10 replies

  11 years, 8 months ago

  By: Raunak Jhawar

• using dtutil in ssis2008

  I would like to know how to check for existing ssis package in file system for example in c drive o…

  sej2008

  2 replies

  11 years, 8 months ago

  By: Raunak Jhawar

• SSRS and SSIS Deployment Process

  Can anyone provide me the best practice procedures for deploying SSIS and/or SSRS from the developm…

  Motomoto

  2 replies

  11 years, 8 months ago

  By: Koen Verbeeck

• fail job scheduled when package fails

  Hi I have one of my sql agent job scheduled and it is always success though the package execution f…

  Anil Kolla

  1 replies

  11 years, 8 months ago

  By: free_mascot

• Error while exporting data from SQL to Access

  Hi, I am developing a SSIS package where I am trying to pull records from SQL server tables and pus…

  haichells

  6 replies

  11 years, 8 months ago

  By: herladygeekedness

• OlapEvent = ObjIdUpdate(2)

  Hi All When I execute sp_WhoIsActive to see who is active, I constantly see this running select SEL…

  Igor Micev

  1 replies

  11 years, 8 months ago

  By: Igor Micev