Business Intelligence

• Topics

  Started by

  Posts

  Last post

• SQL Reporting Services Report taking LONG time to process

  Hi all, I've a query which is taking 10 to 20 sec when i execute it from SSMS. But when i execute t…

  ramu.valleti

  15 replies

  12 years, 7 months ago

  By: shruthy123

• SSRS DEPLOYEMENT PROBLEM

  Hi every body, I created a report with SSRS without problem, but when I tried to deploy it , I rece…

  Saturnem31

  8 replies

  12 years, 7 months ago

  By: Saturnem31

• dynamic import of multiple flat files

  hi need your help regarding dynamically importing multiple flat files into different table of sql s…

  lakshyanda

  15 replies

  12 years, 7 months ago

  By: Orlando Colamatteo

• deleting rows from a table after processing them in SSIS

  Hi Guys, I am a newbie and I need to do the following task: I have to process the rows in one table…

  trailblazer

  7 replies

  12 years, 7 months ago

  By: trailblazer

• Crear Documentacion de Pacquete o proyecto ssis 2008

  Estimados. Muy Buenos Dias, mi Pregunta es la siguiente: existe alguna opcion en ssis 2008 que me p…

  rcherod

  2 replies

  12 years, 7 months ago

  By: Ed Zann

• Get the Column information(ole db source and ole db destination) from DTSX (SSIS package) file using C#

  HI, I have lots of SSIS packages and i have to make the column mapping sheet for the SSIS packages …

  Anshuman Saini

  7 replies

  12 years, 7 months ago

  By: Orlando Colamatteo

• SSIS - XML Source to OLE DB Command problem

  I have an SSIS package that is trying to pull from an XML Source and into an OLE DB Command. My g…

  head_contusion

  3 replies

  12 years, 8 months ago

  By: abed_alghali

• Urgent help - foreach loop container

  My case is very simple but I can't resolve the issue using SQL Server 2008R2 BIDS. I need to select…

  whly

  4 replies

  12 years, 8 months ago

  By: Jeff Moden

• ETL Load Approach

  We have a table 'Sales' which is Fully loaded daily. Our target delivery is insert else update, So …

  SelwynRaj

  7 replies

  12 years, 8 months ago

  By: sdevanny

• urgent help related to Report Column Expression

  I have a report where one of the column called Cost is of number data type So below is the require…

  Lucky9

  1 replies

  12 years, 8 months ago

  By: stevefromOZ

• How to insert new record for a user having multiple records by performing lookup?

  Hi, I have one table called Student. The source for loading the table is StudentHistory. My Scenari…

  deepthipriya.ravi

  6 replies

  12 years, 8 months ago

  By: MMartin1

• How to Compare Data between to servers based in Id's

  Hi All, I have a requirement like, Identify the out of sync records from two servers. I have Id's t…

  Tony1234

  6 replies

  12 years, 8 months ago

  By: MMartin1

• SSIS to Load selected CSV File columns into SQL Server 2008 database table

  Hi, The source file format in CSV, lets assume it has following data id name …

  vijayakumarkj-602216

  1 replies

  12 years, 8 months ago

  By: Jack Corbett

• SSIS-Data in multiple .csv files to columns in same csv file

  Hi Everyone I have the below problem,could anyone please suggest me a solution. file 1 has below da…

  avinash.818

  11 replies

  12 years, 8 months ago

  By: Brandie Tarvin

• Foreign key constraints in data warehouses

  I am just learning about data warehousing and business intelligence, and reading Ralph Kimball’s ex…

  Chuck Bevitt

  35 replies

  12 years, 8 months ago

  By: TangoVictor