Business Intelligence

• Topics

  Started by

  Posts

  Last post

• Could Active Directory Be Causing a connection manager to point to wrong server

  I have a connection manager that is getting its connection string from table. I've checked the tabl…

  dndaughtery

  3 replies

  11 years, 4 months ago

  By: Ant-Green

• SSRS 2005 Issue with multi value parameters resetting after selection

  Hi All, My first time posting here, I have tried searching for this issue but haven't seemed to fin…

  jwheeler-985942

  1 replies

  11 years, 4 months ago

  By: a121719

• using IDENTITY INSERT

  After reading this: http://www.sqlteam.com/article/how-to-insert-values-into-an-identity-column-in-…

  ipisors

  13 replies

  11 years, 4 months ago

  By: ipisors

• ssis Training

  i am new to ssis .how to prepare ssis ? plz help me

  sanjay.kumarpatra

  1 replies

  11 years, 4 months ago

  By: Luis Cazares

• SSRS-Adding a subgroup to a group column

  Here is my scenario: I have a matrix report which looks like this: Project Hours …

  kingankit2006

  1 replies

  11 years, 4 months ago

  By: pietlinden

• SSIS Packages Real Time Work?

  May i know What is The Purpose Of SSIS Packages Related to any One Real Time Project With Example?

  vamsikrishna.nelakuditi

  3 replies

  11 years, 4 months ago

  By: sqlvogel

• SSIS: DTS_E_OLEDBERROR and DTS_E_PRIMEOUTPUTFAILED

  Hi Guys, I have a Simple Package that Loads Data from Oracle Table to Sql Server Table. For Source …

  Mr. Kapsicum

  10 replies

  11 years, 4 months ago

  By: Koen Verbeeck

• What are the best way to move data securely over the network by SSIS?

  Need to design ssis package to copy data from local database server to another database server whic…

  harsimranjeetsinghwasson

  8 replies

  11 years, 5 months ago

  By: harsimranjeetsinghwasson

• Problems Using Expressions to control the Visibility ToggleItem (SSRS 2005)

  Hi, I have a problem I am hoping someone out there knows the answer to. I have a report with up to…

  jdrintnt

  5 replies

  11 years, 5 months ago

  By: tripleAxe

• SSRS hide column

  I want to hide one of my column based on this logic; =IIf(First(Fields!TOLERANCE_CHECK.Value, "NetU…

  hoseam

  2 replies

  11 years, 5 months ago

  By: David Burrows

• How to validate data of a flat file source with the data of different tables of my database?

  Hi All, I am trying to find a solution for my task. My task is, I have a Flat File Source data. Usi…

  Vallu

  5 replies

  11 years, 5 months ago

  By: John Mitchell-245523

• Custom SSIS sql task failed

  I am developing a custom SSIS task for running sql task. But it fails with error - I'm trying to se…

  sumitpkedia

  6 replies

  11 years, 5 months ago

  By: Umer Akram

• SSIS help in deriving negative values

  Hi, I have a requirement where from a string we need to derive the amount and also based on the alp…

  rkota2008

  5 replies

  11 years, 5 months ago

  By: Evil Kraig F

• Default parameter to today's date

  Hi I'm Using VS 2010 and working on a SSRS report, I have one parameter that I want to set it to cu…

  hoseam

  1 replies

  11 years, 5 months ago

  By: Jack Corbett

• Event Handlers. Onerror Vs OnFailure

  I want to add a sendMail task so that if a task fails or has an error an email is sent with the err…

  dndaughtery

  1 replies

  11 years, 5 months ago

  By: jvolaire